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

Line 850: FROM fnd_lookup_values

846:
847: BEGIN
848: SELECT MSC_UTIL.SYS_YES
849: INTO lv_status_decided_bom
850: FROM fnd_lookup_values
851: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
852: enabled_flag = 'Y' AND
853: view_application_id = 700 AND
854: language = userenv('lang') AND

Line 1334: FROM fnd_lookup_values

1330: --lv_bor1
1331: BEGIN
1332: SELECT MSC_UTIL.SYS_YES
1333: INTO lv_status_decided_bor
1334: FROM fnd_lookup_values
1335: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1336: enabled_flag = 'Y' AND
1337: view_application_id = 700 AND
1338: language = userenv('lang') AND

Line 1378: FROM fnd_lookup_values

1374:
1375: BEGIN
1376: SELECT MSC_UTIL.SYS_YES
1377: INTO lv_status_decided_item
1378: FROM fnd_lookup_values
1379: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1380: enabled_flag = 'Y' AND
1381: view_application_id = 700 AND
1382: language = userenv('lang') AND

Line 1456: FROM fnd_lookup_values

1452: --lv_oh1
1453: BEGIN
1454: SELECT MSC_UTIL.SYS_YES
1455: INTO lv_status_decided_oh
1456: FROM fnd_lookup_values
1457: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1458: enabled_flag = 'Y' AND
1459: view_application_id = 700 AND
1460: language = userenv('lang') AND

Line 1508: FROM fnd_lookup_values

1504:
1505: BEGIN
1506: SELECT MSC_UTIL.SYS_YES
1507: INTO lv_status_decided_usup
1508: FROM fnd_lookup_values
1509: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1510: enabled_flag = 'Y' AND
1511: view_application_id = 700 AND
1512: language = userenv('lang') AND

Line 1555: FROM fnd_lookup_values

1551: --p_udmd_sn_flag
1552: BEGIN
1553: SELECT MSC_UTIL.SYS_YES
1554: INTO lv_status_decided_udem
1555: FROM fnd_lookup_values
1556: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1557: enabled_flag = 'Y' AND
1558: view_application_id = 700 AND
1559: language = userenv('lang') AND

Line 1607: FROM fnd_lookup_values

1603: IF (prec.sales_order_flag =MSC_UTIL.SYS_YES) THEN
1604: BEGIN
1605: SELECT MSC_UTIL.SYS_YES
1606: INTO lv_status_decided_so
1607: FROM fnd_lookup_values
1608: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1609: enabled_flag = 'Y' AND
1610: view_application_id = 700 AND
1611: language = userenv('lang') AND

Line 1719: FROM fnd_lookup_values

1715: IF prec.forecast_flag = MSC_UTIL.SYS_YES THEN
1716: BEGIN
1717: SELECT MSC_UTIL.SYS_YES
1718: INTO lv_status_decided_fcst
1719: FROM fnd_lookup_values
1720: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1721: enabled_flag = 'Y' AND
1722: view_application_id = 700 AND
1723: language = userenv('lang') AND

Line 1794: FROM fnd_lookup_values

1790:
1791: BEGIN
1792: SELECT MSC_UTIL.SYS_YES
1793: INTO lv_status_decided_wip
1794: FROM fnd_lookup_values
1795: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1796: enabled_flag = 'Y' AND
1797: view_application_id = 700 AND
1798: language = userenv('lang') AND

Line 2278: FROM fnd_lookup_values

2274: IF prec.app_supp_cap_flag = MSC_UTIL.SYS_YES or prec.app_supp_cap_flag =MSC_UTIL.ASL_YES_RETAIN_CP THEN
2275: BEGIN
2276: SELECT MSC_UTIL.SYS_YES
2277: INTO lv_status_decided_app_supp_cap
2278: FROM fnd_lookup_values
2279: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2280: enabled_flag = 'Y' AND
2281: view_application_id = 700 AND
2282: language = userenv('lang') AND

Line 2329: FROM fnd_lookup_values

2325: IF prec.po_flag = MSC_UTIL.SYS_YES THEN
2326: BEGIN
2327: SELECT MSC_UTIL.SYS_YES
2328: INTO lv_status_decided_po
2329: FROM fnd_lookup_values
2330: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2331: enabled_flag = 'Y' AND
2332: view_application_id = 700 AND
2333: language = userenv('lang') AND

Line 2458: FROM fnd_lookup_values

2454:
2455: BEGIN
2456: SELECT MSC_UTIL.SYS_YES
2457: INTO lv_status_decided_mds
2458: FROM fnd_lookup_values
2459: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2460: enabled_flag = 'Y' AND
2461: view_application_id = 700 AND
2462: language = userenv('lang') AND

Line 2510: FROM fnd_lookup_values

2506: IF prec.mps_flag = MSC_UTIL.SYS_YES THEN
2507: BEGIN
2508: SELECT MSC_UTIL.SYS_YES
2509: INTO lv_status_decided_mps
2510: FROM fnd_lookup_values
2511: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2512: enabled_flag = 'Y' AND
2513: view_application_id = 700 AND
2514: language = userenv('lang') AND

Line 2562: FROM fnd_lookup_values

2558: IF prec.trip_flag = MSC_UTIL.SYS_YES THEN
2559: BEGIN
2560: SELECT MSC_UTIL.SYS_YES
2561: INTO lv_status_decided_trip
2562: FROM fnd_lookup_values
2563: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2564: enabled_flag = 'Y' AND
2565: view_application_id = 700 AND
2566: language = userenv('lang') AND