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 509: FROM fnd_lookup_values_vl

505:
506: -- Bug 3821688 Split Cursor
507: CURSOR check_lookup_code IS
508: SELECT lookup_code
509: FROM fnd_lookup_values_vl
510: WHERE lookup_code = p_lookup_code AND
511: lookup_type = p_lookup_type AND
512: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
513: enabled_flag = 'Y';

Line 517: FROM fnd_lookup_values_vl

513: enabled_flag = 'Y';
514:
515: CURSOR check_lookup_meaning IS
516: SELECT lookup_code
517: FROM fnd_lookup_values_vl
518: WHERE meaning = p_meaning AND
519: lookup_type = p_lookup_type AND
520: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
521: enabled_flag = 'Y';

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

1348:
1349: --========================================================================
1350: -- PROCEDURE : Validate_Ship_Method
1351: --
1352: -- COMMENT : Validates Ship_Method_Code/Name against fnd_lookup_values_vl.
1353: -- If both values are specified then only Ship_Method_Code is used
1354: --========================================================================
1355:
1356: PROCEDURE Validate_Ship_Method

Line 1364: FROM fnd_lookup_values_vl

1360:
1361: -- Bug 3821688 Split Cursor
1362: CURSOR check_ship_method_code IS
1363: SELECT lookup_code, meaning
1364: FROM fnd_lookup_values_vl
1365: WHERE lookup_code = p_ship_method_code AND
1366: lookup_type = 'SHIP_METHOD' AND
1367: view_application_id = 3;
1368:

Line 1371: FROM fnd_lookup_values_vl

1367: view_application_id = 3;
1368:
1369: CURSOR check_ship_method_name IS
1370: SELECT lookup_code, meaning
1371: FROM fnd_lookup_values_vl
1372: WHERE meaning = p_ship_method_name AND
1373: lookup_type = 'SHIP_METHOD' AND
1374: view_application_id = 3;
1375:

Line 4320: from FND_LOOKUP_VALUES_VL

4316:
4317: --Cursor to get the meaning and description of a look up code.
4318: Cursor c_po_fob (p_lookup_code VARCHAR2) IS
4319: SELECT meaning,description
4320: from FND_LOOKUP_VALUES_VL
4321: where lookup_code = p_lookup_code AND
4322: lookup_type = 'FOB' AND
4323: nvl(start_date_active,SYSDATE) <= SYSDATE AND
4324: nvl(end_date_active,SYSDATE) >= SYSDATE AND

Line 4464: FROM FND_LOOKUP_VALUES_VL

4460:
4461: --Cursor to get the meaning and description of a look up code.
4462: Cursor c_po_freight (p_lookup_code VARCHAR2) IS
4463: SELECT meaning,description
4464: FROM FND_LOOKUP_VALUES_VL
4465: WHERE
4466: lookup_type = 'FREIGHT TERMS' AND
4467: lookup_code = p_lookup_code
4468: AND nvl(start_date_active,SYSDATE) <= SYSDATE

Line 5045: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5041:
5042: CURSOR check_ship_method IS
5043: select flv.lookup_code ship_method_code,
5044: flv.meaning
5045: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5046: where flv.lookup_code = wcs.ship_method_code
5047: and wcs.ship_method_code = p_ship_method_code
5048: and flv.lookup_type = 'SHIP_METHOD'
5049: and flv.view_application_id = 3

Line 5054: from fnd_lookup_values_vl flv, wsh_carrier_services wcs

5050: and wcs.enabled_flag='Y'
5051: UNION ALL
5052: select flv.lookup_code ship_method_code,
5053: flv.meaning
5054: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5055: where flv.lookup_code = wcs.ship_method_code
5056: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
5057: and flv.lookup_type = 'SHIP_METHOD'
5058: and flv.view_application_id = 3

Line 5142: FROM fnd_lookup_values_vl

5138:
5139: -- Bug 3821688 Split Cursor
5140: CURSOR check_lookup_code IS
5141: SELECT lookup_code
5142: FROM fnd_lookup_values_vl
5143: WHERE UPPER(lookup_code) = UPPER(p_lookup_code) AND
5144: lookup_type = p_lookup_type AND
5145: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
5146: view_application_id = 660 AND

Line 5151: FROM fnd_lookup_values_vl

5147: enabled_flag = 'Y';
5148:
5149: CURSOR check_lookup_meaning IS
5150: SELECT lookup_code
5151: FROM fnd_lookup_values_vl
5152: WHERE meaning = p_meaning AND
5153: lookup_type = p_lookup_type AND
5154: nvl(start_date_active,sysdate)<=sysdate AND nvl(end_date_active,sysdate)>=sysdate AND
5155: view_application_id = 660 AND