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 5085: fnd_lookup_values fl

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

Line 5651: FROM fnd_lookup_values_vl

5647: CURSOR C_SALESCHANNEL(p_lookup_code varchar2) is
5648: SELECT 1 FROM DUAL WHERE exists
5649: (
5650: SELECT lookup_code
5651: FROM fnd_lookup_values_vl
5652: WHERE lookup_type = 'SALES_CHANNEL'
5653: AND view_application_id = 660
5654: AND enabled_flag = 'Y'
5655: AND trunc( NVL(start_date_active, sysdate) ) <= trunc( sysdate )

Line 9699: fnd_lookup_values fl

9695:
9696: Cursor C_Get_ship_method ( l_ship_method_code varchar2, l_org_id number) is
9697: SELECT csm.ship_method_code
9698: from wsh_carrier_ship_methods csm,
9699: fnd_lookup_values fl
9700: where fl.lookup_type = 'SHIP_METHOD'
9701: and csm.ship_method_code = l_ship_method_code
9702: and fl.view_application_id = 3
9703: and csm.organization_id = l_org_id