Oracle Apps Technical

Tuesday, February 26, 2013

Date format in reports

In reports Parameter use the below format

TRUNC(prh.creation_date)>=nvl(FND_DATE.CANONICAL_TO_DATE(:p_from_date),TRUNC(prh.creation_date))
AND TRUNC(prh.creation_date)<=nvl(FND_DATE.CANONICAL_TO_DATE(:p_to_date),TRUNC(prh.creation_date))

For the above format use the FND_DATE4_REQUIRED_STANDARD valueset.

at February 26, 2013
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2024 (7)
    • ►  September (1)
    • ►  July (3)
    • ►  April (1)
    • ►  February (2)
  • ►  2016 (5)
    • ►  July (1)
    • ►  February (3)
    • ►  January (1)
  • ▼  2013 (11)
    • ►  November (2)
    • ►  September (1)
    • ►  April (1)
    • ►  March (3)
    • ▼  February (4)
      • Date format in reports
      • Query for flex_value valueset
      • Update expense account for the item in mtl_system_...
      • Language set in toad
  • ►  2012 (5)
    • ►  September (1)
    • ►  June (4)
  • ►  2011 (1)
    • ►  June (1)
  • ►  2010 (9)
    • ►  December (3)
    • ►  November (1)
    • ►  May (5)
  • ►  2009 (5)
    • ►  June (1)
    • ►  March (3)
    • ►  February (1)
  • ►  2008 (7)
    • ►  November (7)
  • query for item onhand quantity & Lot wise query
    SELECT  msi.segment1 item_name,mq.subinventory_code, b.SEGMENT1||'.'||b.SEGMENT2||'.'||b.SEGMENT3||'.'||b.SEGMENT4 ...
  • hr_assignment_api.update_emp_asg in HRMS
    create table xx_gosi_update ( emp_no varchar2(240) ,gosi  varchar2(240) ,status varchar2(240) ) Below is the script for update the as...
  • Query for PR PO Receipt Invoice Payments
    --PR and PO (Standard) select distinct prha.requisition_header_id,          prha.segment1 pr_number,          trunc(prha.creation_da...
Simple theme. Powered by Blogger.

Price List API

CREATE OR REPLACE PACKAGE BODY apps."XXABC_AUS_PRICE_LOAD_PKG" AS /*+-------------------------------------------------------------...