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_SCE_COLLECTION dependencies on MSC_COMPANY_SITE_ID_LID

Line 138: -- These records will be found using msc_company_site_id_lid as reference.

134: IF (p_is_complete_refresh) THEN
135:
136: -- ======================================================================================
137: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
138: -- These records will be found using msc_company_site_id_lid as reference.
139: -- ======================================================================================
140: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
141: ' where exists(select 1 '||
142: ' from msc_company_site_id_lid mcsil '||

Line 142: ' from msc_company_site_id_lid mcsil '||

138: -- These records will be found using msc_company_site_id_lid as reference.
139: -- ======================================================================================
140: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
141: ' where exists(select 1 '||
142: ' from msc_company_site_id_lid mcsil '||
143: ' where mcsil.company_site_id = mtpm.company_key '||
144: ' and mcsil.partner_type = 3'||
145: ' and mcsil.sr_instance_id = :v_sr_instance_id ) '||
146: ' and mtpm.map_type = 2';

Line 154: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

150: COMMIT;
151:
152: IF lv_msc_tp_coll_window = 0 THEN
153: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
154: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
155: END IF;
156:
157:
158: -- ======================================================================================

Line 185: -- These records will be found using msc_company_site_id_lid as reference.

181: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
182:
183: -- ======================================================================================
184: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
185: -- These records will be found using msc_company_site_id_lid as reference.
186: -- ======================================================================================
187: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
188: ' where exists(select 1 '||
189: ' from msc_company_site_id_lid mcsil '||

Line 189: ' from msc_company_site_id_lid mcsil '||

185: -- These records will be found using msc_company_site_id_lid as reference.
186: -- ======================================================================================
187: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
188: ' where exists(select 1 '||
189: ' from msc_company_site_id_lid mcsil '||
190: ' where mcsil.company_site_id = mtpm.company_key '||
191: ' and mcsil.partner_type = 3'||
192: ' and mcsil.sr_instance_id = :v_sr_instance_id ) '||
193: ' and mtpm.map_type = 2';

Line 200: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

196:
197: COMMIT;
198: IF lv_msc_tp_coll_window = 0 THEN
199: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
200: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
201: END IF;
202:
203: -- ======================================================================================
204: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".

Line 266: -- Populate msc_company_site_id_lid

262: LOG_MESSAGE('Creating new company sites');
263: CREATE_NEW_COMPANY_SITES;
264: COMMIT;
265:
266: -- Populate msc_company_site_id_lid
267: LOG_MESSAGE('Populating msc_company_site_id_lid');
268: POPULATE_COMPANY_SITE_ID_LID;
269: COMMIT;
270:

Line 267: LOG_MESSAGE('Populating msc_company_site_id_lid');

263: CREATE_NEW_COMPANY_SITES;
264: COMMIT;
265:
266: -- Populate msc_company_site_id_lid
267: LOG_MESSAGE('Populating msc_company_site_id_lid');
268: POPULATE_COMPANY_SITE_ID_LID;
269: COMMIT;
270:
271: -- Collect Company Information

Line 347: msc_company_site_id_lid mcsl,

343: CURSOR updCompanyNameRecords IS
344: SELECT mcs.company_id, mcs.company_site_id,
345: decode(mtps.partner_type,G_SUPPLIER, mtps.tp_site_code, G_CUSTOMER, mtps.LOCATION)
346: FROM msc_st_Trading_partner_sites mtps,
347: msc_company_site_id_lid mcsl,
348: msc_company_sites mcs --bug 5097405
349: WHERE mtps.sr_instance_id = mcsl.sr_instance_id
350: AND mtps.sr_instance_id = v_sr_instance_id
351: AND mtps.partner_type = mcsl.partner_type

Line 745: INSERT INTO MSC_COMPANY_SITE_ID_LID

741: LOG_MESSAGE('POPULATE_COMPANY_SITE_ID_LID started');
742:
743: BEGIN
744:
745: INSERT INTO MSC_COMPANY_SITE_ID_LID
746: ( SR_INSTANCE_ID,
747: SR_COMPANY_ID,
748: SR_COMPANY_SITE_ID,
749: PARTNER_TYPE,

Line 768: from msc_company_site_id_lid mcsil

764: and mst.partner_type = G_ORGANIZATION
765: and mcil.company_id = mcs.company_id
766: and mst.organization_code = mcs.company_site_name
767: and not exists (select 1
768: from msc_company_site_id_lid mcsil
769: where mcsil.sr_instance_id = mst.sr_instance_id
770: and mcsil.sr_company_id = nvl(mst.company_id, -1)
771: and mcsil.sr_company_site_id = mst.sr_tp_id
772: and mcsil.partner_type = mst.partner_type

Line 792: from msc_company_site_id_lid mcsil

788: and mcil.company_id = mcs.company_id
789: and decode(mtps.partner_type, 2, mtps.LOCATION,
790: 1, tp_site_code ) = mcs.company_site_name
791: and not exists (select 1
792: from msc_company_site_id_lid mcsil
793: where mcsil.sr_instance_id = mtps.sr_instance_id
794: and mcsil.sr_company_id = mtps.sr_tp_id
795: and mcsil.sr_company_site_id = mtps.sr_tp_site_id
796: and mcsil.partner_type = mtps.partner_type

Line 804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');

800: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
801: LOG_MESSAGE('========================================');
802: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
804: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
805: LOG_MESSAGE(FND_MESSAGE.GET);
806: LOG_MESSAGE(SQLERRM);
807:
808: END;

Line 811: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITE_ID_LID');

807:
808: END;
809: COMMIT;
810: --Bug 5155944: Analysing the table to improve performance
811: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITE_ID_LID');
812:
813: LOG_MESSAGE('Successfully populated MSC_COMPANY_SITE_ID_LID');
814:
815: END POPULATE_COMPANY_SITE_ID_LID;

Line 813: LOG_MESSAGE('Successfully populated MSC_COMPANY_SITE_ID_LID');

809: COMMIT;
810: --Bug 5155944: Analysing the table to improve performance
811: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITE_ID_LID');
812:
813: LOG_MESSAGE('Successfully populated MSC_COMPANY_SITE_ID_LID');
814:
815: END POPULATE_COMPANY_SITE_ID_LID;
816:
817:

Line 1212: msc_company_site_id_lid mcsil

1208: mcil.company_id,
1209: mcsil.company_site_id
1210: from msc_st_item_suppliers msis,
1211: msc_company_id_lid mcil,
1212: msc_company_site_id_lid mcsil
1213: where msis.supplier_id = mcil.sr_company_id
1214: and msis.sr_instance_id = mcil.sr_instance_id
1215: and mcil.partner_type = G_SUPPLIER
1216: and msis.sr_instance_id = p_instance_id

Line 1246: msc_company_site_id_lid mcsil

1242: mcil.company_id,
1243: mcsil.company_site_id
1244: from msc_st_item_customers msic,
1245: msc_company_id_lid mcil,
1246: msc_company_site_id_lid mcsil
1247: where msic.customer_id = mcil.sr_company_id
1248: and msic.sr_instance_id = mcil.sr_instance_id
1249: and mcil.partner_type = G_CUSTOMER
1250: and msic.sr_instance_id = p_instance_id

Line 1341: msc_company_site_id_lid mcsil

1337: SELECT
1338: mcsil.COMPANY_SITE_ID,
1339: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')
1340: from msc_st_trading_partners mtp,
1341: msc_company_site_id_lid mcsil
1342: where nvl(mtp.company_id, -1) = mcsil.sr_company_id
1343: and mtp.sr_instance_id = mcsil.sr_instance_id
1344: and mtp.sr_instance_id = v_sr_instance_id
1345: and mtp.sr_tp_id = mcsil.sr_company_site_id

Line 1367: msc_company_site_id_lid mcsil

1363: mstps.county,
1364: mstps.province,
1365: mstps.postal_code
1366: FROM MSC_ST_TRADING_PARTNER_SITES mstps,
1367: msc_company_site_id_lid mcsil
1368: WHERE mcsil.SR_COMPANY_ID = nvl(mstps.sr_tp_id, -1)
1369: AND mcsil.SR_COMPANY_SITE_ID= mstps.SR_TP_SITE_ID
1370: AND mcsil.SR_INSTANCE_ID= mstps.SR_INSTANCE_ID
1371: AND mcsil.partner_type = mstps.partner_type

Line 1399: msc_company_site_id_lid mcsil

1395: mtps.county,
1396: mtps.province,
1397: mtps.postal_code
1398: from msc_st_trading_partner_sites mtps,
1399: msc_company_site_id_lid mcsil
1400: where nvl(mtps.company_id, -1) = mcsil.sr_company_id
1401: and mtps.sr_instance_id = mcsil.sr_instance_id
1402: and mtps.sr_instance_id = v_sr_instance_id
1403: and mtps.sr_tp_id = mcsil.sr_company_site_id

Line 1631: msc_company_site_id_lid mcsil,

1627: cursor newOrgMap is
1628: select DISTINCT mtp.partner_id,
1629: mcs.company_site_id
1630: from msc_company_sites mcs,
1631: msc_company_site_id_lid mcsil,
1632: msc_trading_partners mtp
1633: where mcs.company_site_id = mcsil.company_site_id
1634: -- Process for the current instance only
1635: and mcsil.sr_instance_id = p_instance_id

Line 1667: msc_company_site_id_lid mcsil,

1663: cursor newTpSIteMap is
1664: select DISTINCT mtsil.tp_site_id,
1665: mcs.company_site_id
1666: from msc_company_sites mcs,
1667: msc_company_site_id_lid mcsil,
1668: msc_tp_site_id_lid mtsil
1669: where mcs.company_site_id = mcsil.company_site_id
1670: and mcsil.sr_instance_id = p_instance_id
1671: and mcsil.sr_instance_id = mtsil.sr_instance_id