APPS.MSC_CL_PUBLISH dependencies on MSC_SUPPLIES

Line 264: msc_supplies ms

260: , itm.item_name
261: , to_number(NULL) --- internal flag
262: ,mi.planner_code --Bug 4424426
263: from
264: msc_supplies ms
265: -- Table to get org equivalent company_site_id
266: ,msc_companies mc
267: ,msc_company_sites mcs
268: ,msc_company_site_id_lid mcsil

Line 383: msc_supplies ms

379: ,to_char(null) -- base item_name
380: , SYS_YES
381: ,mi.planner_code --Bug 4424426
382: from
383: msc_supplies ms
384: , msc_trading_partners mtp
385: -- Table to get customer/customer site
386: ,msc_companies mc
387: ,msc_company_sites mcs

Line 482: from msc_supplies ms

478: ,G_SUPPLIER ALLOCATION_TYPE
479: , mi.base_item_id BASE_ITEM_ID
480: , itm.item_name BASE_ITEM_NAME
481: ,mi.planner_code PLANNER_CODE --Bug 4424426
482: from msc_supplies ms
483: --========================================
484: -- Tables to get Publisher's organization_id
485: --========================================
486: , msc_company_site_id_lid mcsil

Line 622: from msc_supplies ms

618: G_SUPPLIER ALLOCATION_TYPE,
619: mi.base_item_id BASE_ITEM_ID,
620: itm.item_name BASE_ITEM_NAME,
621: mi.planner_code PLANNER_CODE --Bug 4424426
622: from msc_supplies ms
623: --========================================
624: -- Tables to get Publisher's organization_id
625: --========================================
626: , msc_company_site_id_lid mcsil

Line 767: from msc_supplies ms

763: G_CUSTOMER ALLOCATION_TYPE,
764: mi.base_item_id BASE_ITEM_ID,
765: itm.item_name BASE_ITEM_NAME,
766: mi.planner_code PLANNER_CODE --Bug 4424426
767: from msc_supplies ms
768: --========================================
769: -- Tables to get Publisher's organization_id
770: --========================================
771: , msc_company_site_id_lid mcsil

Line 916: from msc_supplies ms

912: , G_SUPPLIER ALLOCATION_TYPE
913: , mi.base_item_id BASE_ITEM_ID
914: , itm.item_name BASE_ITEM_NAME
915: ,mi.planner_code PLANNER_CODE --Bug 4424426
916: from msc_supplies ms
917: --========================================
918: -- Tables to get Publisher's organization_id
919: --========================================
920: , msc_company_site_id_lid mcsil

Line 986: from msc_supplies ms1

982: (--==========================================
983: -- Local View to get Net change information.
984: --==========================================
985: select 1
986: from msc_supplies ms1
987: where plan_id = G_PLAN_ID
988: and sr_instance_id = p_sr_instance_id
989: --==============================================
990: -- Joins for getting net change Item information

Line 1068: from msc_supplies ms

1064: G_SUPPLIER ALLOCATION_TYPE,
1065: mi.base_item_id BASE_ITEM_ID,
1066: itm.item_name BASE_ITEM_NAME
1067: ,mi.planner_code PLANNER_CODE --Bug 4424426
1068: from msc_supplies ms
1069: --========================================
1070: -- Tables to get Publisher's organization_id
1071: --========================================
1072: , msc_company_site_id_lid mcsil

Line 1144: from msc_supplies ms1,

1140: (--==========================================
1141: -- Local View to get Net change information.
1142: --==========================================
1143: select 1
1144: from msc_supplies ms1,
1145: msc_trading_partners mtp2
1146: where plan_id = G_PLAN_ID /* Changes for modeled suppliers sbala */
1147: and ms1.sr_instance_id = p_sr_instance_id
1148: --==============================================

Line 1230: from msc_supplies ms

1226: G_CUSTOMER ALLOCATION_TYPE,
1227: mi.base_item_id BASE_ITEM_ID,
1228: itm.item_name BASE_ITEM_NAME
1229: ,mi.planner_code PLANNER_CODE --Bug 4424426
1230: from msc_supplies ms
1231: --========================================
1232: -- Tables to get Publisher's organization_id
1233: --========================================
1234: , msc_company_site_id_lid mcsil

Line 1306: from msc_supplies ms1,

1302: --==========================================
1303: -- Local View to get Net change information.
1304: --==========================================
1305: (select 1
1306: from msc_supplies ms1,
1307: msc_trading_partners mtp2
1308: where plan_id = G_PLAN_ID /* Changes for modeled customers sbala */
1309: and ms1.sr_instance_id = p_sr_instance_id
1310: and ms1.order_type = G_MRP_ONHAND

Line 1389: msc_supplies ms,

1385: ,mi.planner_code PLANNER_CODE --Bug 4424426
1386: FROM msc_company_site_id_lid mcsil,
1387: msc_company_sites mcs,
1388: msc_companies mc,
1389: msc_supplies ms,
1390: msc_system_items mi,
1391: msc_items itm,
1392: msc_trading_partners mtp,
1393: fnd_lookup_values flv

Line 1478: msc_supplies ms,

1474: ,mi.planner_code PLANNER_CODE --Bug 4424426
1475: FROM msc_company_site_id_lid mcsil,
1476: msc_company_sites mcs,
1477: msc_companies mc,
1478: msc_supplies ms,
1479: msc_system_items mi,
1480: msc_items itm,
1481: msc_trading_partners mtp,
1482: fnd_lookup_values flv

Line 1518: from msc_supplies ms1

1514: -- Local View to get Net change information.
1515: -- at Item - Organizatoin level.
1516: --==========================================
1517: (select 1
1518: from msc_supplies ms1
1519: where plan_id = G_PLAN_ID
1520: and sr_instance_id = p_sr_instance_id
1521: and ms1.order_type = G_MRP_ONHAND
1522: and ms.plan_id = ms1.plan_id

Line 1775: , msc_supplies ms

1771: ,mi.planner_code PLANNER_CODE --Bug 4424426
1772: from msc_sales_orders mso
1773: , msc_trading_partners mtp
1774: , msc_trading_partner_maps mtpm
1775: , msc_supplies ms
1776: , msc_trading_partners mtp2
1777: , msc_trading_partner_maps map2
1778: , msc_trading_partner_maps mtpm_org
1779: , msc_company_sites mcs_org

Line 1929: msc_supplies ms,

1925: msc_trading_partners mtp,
1926: msc_trading_partner_maps map,
1927: msc_company_sites mcs,
1928: msc_companies mc,
1929: msc_supplies ms,
1930: msc_trading_partners mtp2,
1931: msc_trading_partner_maps map2,
1932: msc_company_sites mcs2,
1933: msc_companies mc2,