APPS.MSC_CL_PUBLISH dependencies on MSC_COMPANY_SITE_ID_LID

Line 268: ,msc_company_site_id_lid mcsil

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
269: -- Tables to get Supplier's company_id
270: ,msc_trading_partner_maps mtpm
271: ,msc_company_relationships mcr
272: ,msc_companies mc1

Line 287: -- Join with msc_company_site_id_lid to get org equivalent company_site_id

283: -- Get PO related transactions
284: and order_type IN (1,2,8,11)
285: -- Get only ODS records
286: and ms.plan_id = G_PLAN_ID
287: -- Join with msc_company_site_id_lid to get org equivalent company_site_id
288: and ms.organization_id = mcsil.sr_company_site_id
289: and ms.sr_instance_id = mcsil.sr_instance_id
290: and mcsil.partner_type = G_ORGANIZATION
291: and mcsil.sr_company_id = G_SR_OEM_ID

Line 486: , msc_company_site_id_lid mcsil

482: from msc_supplies ms
483: --========================================
484: -- Tables to get Publisher's organization_id
485: --========================================
486: , msc_company_site_id_lid mcsil
487: , msc_company_sites mcs
488: , msc_companies mc
489: --========================================
490: -- Tables to get Supplier's information

Line 626: , msc_company_site_id_lid mcsil

622: from msc_supplies ms
623: --========================================
624: -- Tables to get Publisher's organization_id
625: --========================================
626: , msc_company_site_id_lid mcsil
627: , msc_company_sites mcs
628: , msc_companies mc
629: --========================================
630: -- Tables to get Supplier's information

Line 771: , msc_company_site_id_lid mcsil

767: from msc_supplies ms
768: --========================================
769: -- Tables to get Publisher's organization_id
770: --========================================
771: , msc_company_site_id_lid mcsil
772: , msc_company_sites mcs
773: , msc_companies mc
774: --========================================
775: -- Tables to get Supplier's information

Line 920: , msc_company_site_id_lid mcsil

916: from msc_supplies ms
917: --========================================
918: -- Tables to get Publisher's organization_id
919: --========================================
920: , msc_company_site_id_lid mcsil
921: , msc_company_sites mcs
922: , msc_companies mc
923: --========================================
924: -- Tables to get Supplier's information

Line 1072: , msc_company_site_id_lid mcsil

1068: from msc_supplies ms
1069: --========================================
1070: -- Tables to get Publisher's organization_id
1071: --========================================
1072: , msc_company_site_id_lid mcsil
1073: , msc_company_sites mcs
1074: , msc_companies mc
1075:
1076: --========================================

Line 1234: , msc_company_site_id_lid mcsil

1230: from msc_supplies ms
1231: --========================================
1232: -- Tables to get Publisher's organization_id
1233: --========================================
1234: , msc_company_site_id_lid mcsil
1235: , msc_company_sites mcs
1236: , msc_companies mc
1237:
1238: --========================================

Line 1386: FROM msc_company_site_id_lid mcsil,

1382: SUM(nvl(ms.new_order_quantity,0)) PRIMARY_QUANTITY,
1383: mi.base_item_id BASE_ITEM_ID,
1384: itm.item_name BASE_ITEM_NAME
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,

Line 1475: FROM msc_company_site_id_lid mcsil,

1471: SUM(nvl(ms.new_order_quantity,0)) PRIMARY_QUANTITY,
1472: mi.base_item_id BASE_ITEM_ID,
1473: itm.item_name BASE_ITEM_NAME
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,

Line 1619: , msc_company_site_id_lid mcsil

1615: from msc_sales_orders mso
1616: --========================================
1617: -- Tables to get Publisher's organization_id
1618: --========================================
1619: , msc_company_site_id_lid mcsil
1620: , msc_company_sites mcs
1621: , msc_companies mc
1622: , msc_trading_partners mtp
1623: --========================================

Line 4864: ' msc_company_site_id_lid mcsil ,'||

4860: ' ,mavv.status_code '||
4861: ' ,msi.planner_code '||
4862: ' from msc_system_items msi ,'||
4863: ' msc_trading_partners mtp ,'||
4864: ' msc_company_site_id_lid mcsil ,'||
4865: ' msc_company_sites mcs ,'||
4866: ' msc_companies mc ,'||
4867: ' msc_sup_dem_entries asn ,'||
4868: ' msc_company_relationships mcr ,'||

Line 4941: ' msc_company_site_id_lid mcsil,'||

4937: ' ,mavv.status_code '||
4938: ' ,msi.planner_code '||
4939: ' from msc_system_items msi,'||
4940: ' msc_trading_partners mtp,'||
4941: ' msc_company_site_id_lid mcsil,'||
4942: ' msc_company_sites mcs,'||
4943: ' msc_companies mc,'||
4944: ' msc_sup_dem_entries asn,'||
4945: ' msc_company_relationships mcr,'||

Line 5020: ' msc_company_site_id_lid mcsil,'||

5016: ' ,msi.planner_code '||
5017: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5018: ' msc_system_items msi,'||
5019: ' msc_trading_partners mtp,'||
5020: ' msc_company_site_id_lid mcsil,'||
5021: ' msc_company_sites mcs,'||
5022: ' msc_companies mc,'||
5023: ' msc_sup_dem_entries asn,'||
5024: ' msc_company_relationships mcr,'||

Line 5097: ' msc_company_site_id_lid mcsil,'||

5093: ' ,msi.planner_code '||
5094: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5095: ' msc_system_items msi,'||
5096: ' msc_trading_partners mtp,'||
5097: ' msc_company_site_id_lid mcsil,'||
5098: ' msc_company_sites mcs,'||
5099: ' msc_companies mc,'||
5100: ' msc_sup_dem_entries asn,'||
5101: ' msc_company_relationships mcr,'||

Line 5175: ' msc_company_site_id_lid mcsil ,'||

5171: ' ,mavv.status_code '||
5172: ' ,msi.planner_code '||
5173: ' from msc_system_items msi ,'||
5174: ' msc_trading_partners mtp ,'||
5175: ' msc_company_site_id_lid mcsil ,'||
5176: ' msc_company_sites mcs ,'||
5177: ' msc_companies mc ,'||
5178: ' msc_sup_dem_entries asn ,'||
5179: ' msc_company_relationships mcr ,'||

Line 5252: ' msc_company_site_id_lid mcsil,'||

5248: ' ,mavv.status_code '||
5249: ' ,msi.planner_code '||
5250: ' from msc_system_items msi,'||
5251: ' msc_trading_partners mtp,'||
5252: ' msc_company_site_id_lid mcsil,'||
5253: ' msc_company_sites mcs,'||
5254: ' msc_companies mc,'||
5255: ' msc_sup_dem_entries asn,'||
5256: ' msc_company_relationships mcr,'||

Line 5331: ' msc_company_site_id_lid mcsil,'||

5327: ' ,msi.planner_code '||
5328: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5329: ' msc_system_items msi,'||
5330: ' msc_trading_partners mtp,'||
5331: ' msc_company_site_id_lid mcsil,'||
5332: ' msc_company_sites mcs,'||
5333: ' msc_companies mc,'||
5334: ' msc_sup_dem_entries asn,'||
5335: ' msc_company_relationships mcr,'||

Line 5408: ' msc_company_site_id_lid mcsil,'||

5404: ' ,msi.planner_code '||
5405: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5406: ' msc_system_items msi,'||
5407: ' msc_trading_partners mtp,'||
5408: ' msc_company_site_id_lid mcsil,'||
5409: ' msc_company_sites mcs,'||
5410: ' msc_companies mc,'||
5411: ' msc_sup_dem_entries asn,'||
5412: ' msc_company_relationships mcr,'||