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.ASO_VALIDATE_PVT dependencies on FND_LOOKUP_VALUES

Line 5082: fnd_lookup_values fl

5078: IS
5079: CURSOR C_ship_method_code (p_org_id NUMBER) IS
5080: SELECT start_date_active, end_date_active
5081: FROM wsh_carrier_ship_methods csm,
5082: fnd_lookup_values fl
5083: WHERE csm.ship_method_code = p_ship_method_code
5084: AND csm.organization_id = p_org_id
5085: AND csm.enabled_flag = 'Y'
5086: AND fl.lookup_type = 'SHIP_METHOD'

Line 5635: FROM fnd_lookup_values_vl

5631: CURSOR C_SALESCHANNEL(p_lookup_code varchar2) is
5632: SELECT 1 FROM DUAL WHERE exists
5633: (
5634: SELECT lookup_code
5635: FROM fnd_lookup_values_vl
5636: WHERE lookup_type = 'SALES_CHANNEL'
5637: AND view_application_id = 660
5638: AND enabled_flag = 'Y'
5639: AND trunc( NVL(start_date_active, sysdate) ) <= trunc( sysdate )

Line 9651: fnd_lookup_values fl

9647:
9648: Cursor C_Get_ship_method ( l_ship_method_code varchar2, l_org_id number) is
9649: SELECT csm.ship_method_code
9650: from wsh_carrier_ship_methods csm,
9651: fnd_lookup_values fl
9652: where fl.lookup_type = 'SHIP_METHOD'
9653: and csm.ship_method_code = l_ship_method_code
9654: and fl.view_application_id = 3
9655: and csm.organization_id = l_org_id