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.WSH_UTIL_VALIDATE dependencies on FND_LOOKUP_VALUES_VL

Line 531: FROM fnd_lookup_values_vl

527:
528: -- Bug 3821688 Split Cursor
529: CURSOR check_lookup_code IS
530: SELECT lookup_code
531: FROM fnd_lookup_values_vl
532: WHERE lookup_code = p_lookup_code AND
533: lookup_type = p_lookup_type AND
534: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
535: enabled_flag = 'Y';

Line 539: FROM fnd_lookup_values_vl

535: enabled_flag = 'Y';
536:
537: CURSOR check_lookup_meaning IS
538: SELECT lookup_code
539: FROM fnd_lookup_values_vl
540: WHERE meaning = p_meaning AND
541: lookup_type = p_lookup_type AND
542: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
543: enabled_flag = 'Y';

Line 1374: -- COMMENT : Validates Ship_Method_Code/Name against fnd_lookup_values_vl.

1370:
1371: --========================================================================
1372: -- PROCEDURE : Validate_Ship_Method
1373: --
1374: -- COMMENT : Validates Ship_Method_Code/Name against fnd_lookup_values_vl.
1375: -- If both values are specified then only Ship_Method_Code is used
1376: --========================================================================
1377:
1378: PROCEDURE Validate_Ship_Method

Line 1386: FROM fnd_lookup_values_vl

1382:
1383: -- Bug 3821688 Split Cursor
1384: CURSOR check_ship_method_code IS
1385: SELECT lookup_code, meaning
1386: FROM fnd_lookup_values_vl
1387: WHERE lookup_code = p_ship_method_code AND
1388: lookup_type = 'SHIP_METHOD' AND
1389: view_application_id = 3;
1390:

Line 1393: FROM fnd_lookup_values_vl

1389: view_application_id = 3;
1390:
1391: CURSOR check_ship_method_name IS
1392: SELECT lookup_code, meaning
1393: FROM fnd_lookup_values_vl
1394: WHERE meaning = p_ship_method_name AND
1395: lookup_type = 'SHIP_METHOD' AND
1396: view_application_id = 3;
1397:

Line 4364: from FND_LOOKUP_VALUES_VL

4360:
4361: --Cursor to get the meaning and description of a look up code.
4362: Cursor c_po_fob (p_lookup_code VARCHAR2) IS
4363: SELECT meaning,description
4364: from FND_LOOKUP_VALUES_VL
4365: where lookup_code = p_lookup_code AND
4366: lookup_type = 'FOB' AND
4367: nvl(start_date_active,SYSDATE) <= SYSDATE AND
4368: nvl(end_date_active,SYSDATE) >= SYSDATE AND

Line 4508: FROM FND_LOOKUP_VALUES_VL

4504:
4505: --Cursor to get the meaning and description of a look up code.
4506: Cursor c_po_freight (p_lookup_code VARCHAR2) IS
4507: SELECT meaning,description
4508: FROM FND_LOOKUP_VALUES_VL
4509: WHERE
4510: lookup_type = 'FREIGHT TERMS' AND
4511: lookup_code = p_lookup_code
4512: AND nvl(start_date_active,SYSDATE) <= SYSDATE

Line 5089: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5085:
5086: CURSOR check_ship_method IS
5087: select flv.lookup_code ship_method_code,
5088: flv.meaning
5089: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5090: where flv.lookup_code = wcs.ship_method_code
5091: and wcs.ship_method_code = p_ship_method_code
5092: and flv.lookup_type = 'SHIP_METHOD'
5093: and flv.view_application_id = 3

Line 5098: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5094: and wcs.enabled_flag='Y'
5095: UNION ALL
5096: select flv.lookup_code ship_method_code,
5097: flv.meaning
5098: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5099: where flv.lookup_code = wcs.ship_method_code
5100: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
5101: and flv.lookup_type = 'SHIP_METHOD'
5102: and flv.view_application_id = 3

Line 5186: FROM fnd_lookup_values_vl

5182:
5183: -- Bug 3821688 Split Cursor
5184: CURSOR check_lookup_code IS
5185: SELECT lookup_code
5186: FROM fnd_lookup_values_vl
5187: WHERE UPPER(lookup_code) = UPPER(p_lookup_code) AND
5188: lookup_type = p_lookup_type AND
5189: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
5190: view_application_id = 660 AND

Line 5195: FROM fnd_lookup_values_vl

5191: enabled_flag = 'Y';
5192:
5193: CURSOR check_lookup_meaning IS
5194: SELECT lookup_code
5195: FROM fnd_lookup_values_vl
5196: WHERE meaning = p_meaning AND
5197: lookup_type = p_lookup_type AND
5198: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
5199: view_application_id = 660 AND