eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on FND_DATE

Line 663: AND fnd_date.canonical_to_date(sysdate) BETWEEN fnd_date.canonical_to_date(NVL(START_DATE_ACTIVE,sysdate))

659: SELECT inventory_item_id
660: FROM mtl_system_items_vl
661: WHERE (organization_id = FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID'))
662: AND ENABLED_FLAG = 'Y'
663: AND fnd_date.canonical_to_date(sysdate) BETWEEN fnd_date.canonical_to_date(NVL(START_DATE_ACTIVE,sysdate))
664: AND fnd_date.canonical_to_date(NVL(END_DATE_ACTIVE,sysdate))
665: AND concatenated_segments = cv_item_number ;
666:
667: -- ;

Line 664: AND fnd_date.canonical_to_date(NVL(END_DATE_ACTIVE,sysdate))

660: FROM mtl_system_items_vl
661: WHERE (organization_id = FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID'))
662: AND ENABLED_FLAG = 'Y'
663: AND fnd_date.canonical_to_date(sysdate) BETWEEN fnd_date.canonical_to_date(NVL(START_DATE_ACTIVE,sysdate))
664: AND fnd_date.canonical_to_date(NVL(END_DATE_ACTIVE,sysdate))
665: AND concatenated_segments = cv_item_number ;
666:
667: -- ;
668: