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 843: FROM fnd_lookup_values

839:
840: BEGIN
841: SELECT MSC_UTIL.SYS_YES
842: INTO lv_status_decided_bom
843: FROM fnd_lookup_values
844: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
845: enabled_flag = 'Y' AND
846: view_application_id = 700 AND
847: language = userenv('lang') AND

Line 1327: FROM fnd_lookup_values

1323: --lv_bor1
1324: BEGIN
1325: SELECT MSC_UTIL.SYS_YES
1326: INTO lv_status_decided_bor
1327: FROM fnd_lookup_values
1328: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1329: enabled_flag = 'Y' AND
1330: view_application_id = 700 AND
1331: language = userenv('lang') AND

Line 1371: FROM fnd_lookup_values

1367:
1368: BEGIN
1369: SELECT MSC_UTIL.SYS_YES
1370: INTO lv_status_decided_item
1371: FROM fnd_lookup_values
1372: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1373: enabled_flag = 'Y' AND
1374: view_application_id = 700 AND
1375: language = userenv('lang') AND

Line 1449: FROM fnd_lookup_values

1445: --lv_oh1
1446: BEGIN
1447: SELECT MSC_UTIL.SYS_YES
1448: INTO lv_status_decided_oh
1449: FROM fnd_lookup_values
1450: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1451: enabled_flag = 'Y' AND
1452: view_application_id = 700 AND
1453: language = userenv('lang') AND

Line 1501: FROM fnd_lookup_values

1497:
1498: BEGIN
1499: SELECT MSC_UTIL.SYS_YES
1500: INTO lv_status_decided_usup
1501: FROM fnd_lookup_values
1502: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1503: enabled_flag = 'Y' AND
1504: view_application_id = 700 AND
1505: language = userenv('lang') AND

Line 1548: FROM fnd_lookup_values

1544: --p_udmd_sn_flag
1545: BEGIN
1546: SELECT MSC_UTIL.SYS_YES
1547: INTO lv_status_decided_udem
1548: FROM fnd_lookup_values
1549: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1550: enabled_flag = 'Y' AND
1551: view_application_id = 700 AND
1552: language = userenv('lang') AND

Line 1600: FROM fnd_lookup_values

1596: IF (prec.sales_order_flag =MSC_UTIL.SYS_YES) THEN
1597: BEGIN
1598: SELECT MSC_UTIL.SYS_YES
1599: INTO lv_status_decided_so
1600: FROM fnd_lookup_values
1601: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1602: enabled_flag = 'Y' AND
1603: view_application_id = 700 AND
1604: language = userenv('lang') AND

Line 1712: FROM fnd_lookup_values

1708: IF prec.forecast_flag = MSC_UTIL.SYS_YES THEN
1709: BEGIN
1710: SELECT MSC_UTIL.SYS_YES
1711: INTO lv_status_decided_fcst
1712: FROM fnd_lookup_values
1713: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1714: enabled_flag = 'Y' AND
1715: view_application_id = 700 AND
1716: language = userenv('lang') AND

Line 1761: FROM fnd_lookup_values

1757:
1758: BEGIN
1759: SELECT MSC_UTIL.SYS_YES
1760: INTO lv_status_decided_wip
1761: FROM fnd_lookup_values
1762: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
1763: enabled_flag = 'Y' AND
1764: view_application_id = 700 AND
1765: language = userenv('lang') AND

Line 2245: FROM fnd_lookup_values

2241: IF prec.app_supp_cap_flag = MSC_UTIL.SYS_YES or prec.app_supp_cap_flag =MSC_UTIL.ASL_YES_RETAIN_CP THEN
2242: BEGIN
2243: SELECT MSC_UTIL.SYS_YES
2244: INTO lv_status_decided_app_supp_cap
2245: FROM fnd_lookup_values
2246: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2247: enabled_flag = 'Y' AND
2248: view_application_id = 700 AND
2249: language = userenv('lang') AND

Line 2296: FROM fnd_lookup_values

2292: IF prec.po_flag = MSC_UTIL.SYS_YES THEN
2293: BEGIN
2294: SELECT MSC_UTIL.SYS_YES
2295: INTO lv_status_decided_po
2296: FROM fnd_lookup_values
2297: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2298: enabled_flag = 'Y' AND
2299: view_application_id = 700 AND
2300: language = userenv('lang') AND

Line 2425: FROM fnd_lookup_values

2421:
2422: BEGIN
2423: SELECT MSC_UTIL.SYS_YES
2424: INTO lv_status_decided_mds
2425: FROM fnd_lookup_values
2426: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2427: enabled_flag = 'Y' AND
2428: view_application_id = 700 AND
2429: language = userenv('lang') AND

Line 2477: FROM fnd_lookup_values

2473: IF prec.mps_flag = MSC_UTIL.SYS_YES THEN
2474: BEGIN
2475: SELECT MSC_UTIL.SYS_YES
2476: INTO lv_status_decided_mps
2477: FROM fnd_lookup_values
2478: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2479: enabled_flag = 'Y' AND
2480: view_application_id = 700 AND
2481: language = userenv('lang') AND

Line 2529: FROM fnd_lookup_values

2525: IF prec.trip_flag = MSC_UTIL.SYS_YES THEN
2526: BEGIN
2527: SELECT MSC_UTIL.SYS_YES
2528: INTO lv_status_decided_trip
2529: FROM fnd_lookup_values
2530: WHERE lookup_type = 'MSC_COLL_SNAPSHOTS' AND
2531: enabled_flag = 'Y' AND
2532: view_application_id = 700 AND
2533: language = userenv('lang') AND