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.PN_VAR_NATURAL_BP_PKG dependencies on FND_LOOKUPS

Line 655: FROM fnd_lookups fnd1

651:
652: CURSOR sales_type_cur(p_sales_code IN VARCHAR2)
653: IS
654: SELECT fnd1.meaning
655: FROM fnd_lookups fnd1
656: WHERE lookup_type='PN_SALES_CHANNEL'
657: AND lookup_code = p_sales_code
658: AND sysdate between
659: nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)

Line 666: FROM fnd_lookups fnd2

662:
663: CURSOR item_category_cur(p_item_code IN VARCHAR2)
664: IS
665: SELECT fnd2.meaning
666: FROM fnd_lookups fnd2
667: WHERE lookup_type='PN_ITEM_CATEGORY'
668: AND lookup_code = p_item_code
669: AND sysdate between
670: nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)