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_PUBLISH dependencies on FND_LOOKUP_VALUES

Line 280: ,fnd_lookup_values flv

276: -- Table to get global item_id
277: , msc_system_items mi
278: , msc_items itm
279: -- Table to get order type description
280: ,fnd_lookup_values flv
281: where
282: ms.sr_instance_id = p_sr_instance_id
283: -- Get PO related transactions
284: and order_type IN (1,2,8,11)

Line 397: ,fnd_lookup_values flv

393: , msc_companies mc2
394: -- Table to get global item_id
395: ,msc_system_items mi
396: -- Table to get order type description
397: ,fnd_lookup_values flv
398: where
399: ms.sr_instance_id = p_sr_instance_id
400: -- Get Internal Reqs
401: and ms.order_type = 2

Line 504: , fnd_lookup_values flv

500: , msc_items itm
501: --==================================
502: -- Tables to lookup type description
503: --==================================
504: , fnd_lookup_values flv
505: where
506: --============================================
507: -- Joins for getting Allocated On hand records
508: --============================================

Line 645: , fnd_lookup_values flv

641: , msc_items itm
642: --==================================
643: -- Tables to lookup type description
644: --==================================
645: , fnd_lookup_values flv
646: where
647: --============================================
648: -- Joins for getting Allocated On hand records
649: --============================================

Line 790: , fnd_lookup_values flv

786: , msc_items itm
787: --==================================
788: -- Tables to lookup type description
789: --==================================
790: , fnd_lookup_values flv
791: where
792: --============================================
793: -- Joins for getting Allocated On hand records
794: --============================================

Line 938: , fnd_lookup_values flv

934: , msc_items itm
935: --==================================
936: -- Tables to lookup type description
937: --==================================
938: , fnd_lookup_values flv
939: where
940: --============================================
941: -- Joins for getting Allocated On hand records
942: --============================================

Line 1092: , fnd_lookup_values flv

1088: , msc_items itm
1089: --==================================
1090: -- Tables to lookup type description
1091: --==================================
1092: , fnd_lookup_values flv
1093: where
1094: --============================================
1095: -- Joins for getting Allocated On hand records
1096: --============================================

Line 1254: , fnd_lookup_values flv

1250: , msc_items itm
1251: --==================================
1252: -- Tables to lookup type description
1253: --==================================
1254: , fnd_lookup_values flv
1255: where
1256: --============================================
1257: -- Joins for getting Allocated On hand records
1258: --============================================

Line 1393: fnd_lookup_values flv

1389: msc_supplies ms,
1390: msc_system_items mi,
1391: msc_items itm,
1392: msc_trading_partners mtp,
1393: fnd_lookup_values flv
1394: WHERE
1395: ms.plan_id = G_PLAN_ID
1396: and ms.sr_instance_id = p_sr_instance_id
1397: and ms.order_type = G_MRP_ONHAND

Line 1482: fnd_lookup_values flv

1478: msc_supplies ms,
1479: msc_system_items mi,
1480: msc_items itm,
1481: msc_trading_partners mtp,
1482: fnd_lookup_values flv
1483: WHERE
1484: --==============================================
1485: -- Joins for getting net change Item information
1486: --==============================================

Line 1638: , fnd_lookup_values flv

1634: , msc_items itm
1635: --==================================
1636: -- Tables to lookup type description
1637: --==================================
1638: , fnd_lookup_values flv
1639: where
1640: --============================================
1641: -- Joins for Sales Order records
1642: --============================================

Line 1787: , fnd_lookup_values flv

1783: , msc_company_sites mcs
1784: , msc_companies mc
1785: , msc_system_items mi
1786: , msc_items itm
1787: , fnd_lookup_values flv
1788: where
1789: --============================================
1790: -- Joins for Sales Order records
1791: --============================================

Line 1935: fnd_lookup_values flv

1931: msc_trading_partner_maps map2,
1932: msc_company_sites mcs2,
1933: msc_companies mc2,
1934: msc_system_items mi,
1935: fnd_lookup_values flv
1936: where mso.sr_instance_id = p_sr_instance_id
1937: and mso.demand_source_type = 8 --- Internal Sales order
1938: and mso.organization_id = mtp.sr_tp_id
1939: and mso.sr_instance_id = mtp.sr_instance_id

Line 2287: 'select meaning from FND_LOOKUP_VALUES '

2283:
2284: LOG_MESSAGE('The language Code :'||l_language_code);
2285:
2286: execute immediate
2287: 'select meaning from FND_LOOKUP_VALUES '
2288: || ' where LOOKUP_TYPE = ''MSC_X_ORDER_TYPE'' '
2289: || ' and LOOKUP_CODE = 15 '
2290: || ' and LANGUAGE = :l_language_code '
2291: into G_ASN_DESC

Line 2296: 'select meaning from FND_LOOKUP_VALUES '

2292: USING l_language_code;
2293: LOG_DEBUG('The G_ASN_DESC :'||G_ASN_DESC);
2294:
2295: execute immediate
2296: 'select meaning from FND_LOOKUP_VALUES '
2297: || ' where LOOKUP_TYPE = ''MSC_X_ORDER_TYPE'' '
2298: || ' and LOOKUP_CODE = 13 '
2299: || ' and LANGUAGE = :l_language_code '
2300: into G_PO_DESC

Line 2305: 'select meaning from FND_LOOKUP_VALUES '

2301: USING l_language_code;
2302: LOG_DEBUG('The G_PO_DESC :'||G_PO_DESC);
2303:
2304: execute immediate
2305: 'select meaning from FND_LOOKUP_VALUES '
2306: || ' where LOOKUP_TYPE = ''MSC_X_ORDER_TYPE'' '
2307: || ' and LOOKUP_CODE = 20 '
2308: || ' and LANGUAGE = :l_language_code '
2309: into G_REQ_DESC

Line 2316: from fnd_lookup_values

2312:
2313: BEGIN
2314: select MEANING
2315: into G_SHIP_CONTROL
2316: from fnd_lookup_values
2317: where LOOKUP_TYPE = l_shipping_ctrl_lktype
2318: and LOOKUP_CODE =l_ship_lkcode
2319: and language = l_language_code;
2320: LOG_DEBUG('G_SHIP_CONTROL :'||G_SHIP_CONTROL);

Line 2324: from fnd_lookup_values

2320: LOG_DEBUG('G_SHIP_CONTROL :'||G_SHIP_CONTROL);
2321:
2322: select MEANING
2323: into G_ARRIVE_CONTROL
2324: from fnd_lookup_values
2325: where LOOKUP_TYPE = l_shipping_ctrl_lktype
2326: and LOOKUP_CODE =l_arrive_lkcode
2327: and language = l_language_code;
2328: LOG_DEBUG('G_ARRIVE_CONTROL :'||G_ARRIVE_CONTROL);