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 159: -- These records will be found using msc_company_site_id_lid as reference.

155: IF (p_is_complete_refresh) THEN
156:
157: -- ======================================================================================
158: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
159: -- These records will be found using msc_company_site_id_lid as reference.
160: -- ======================================================================================
161: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
162: ' where exists(select 1 '||
163: ' from msc_company_site_id_lid mcsil '||

Line 163: ' from msc_company_site_id_lid mcsil '||

159: -- These records will be found using msc_company_site_id_lid as reference.
160: -- ======================================================================================
161: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
162: ' where exists(select 1 '||
163: ' from msc_company_site_id_lid mcsil '||
164: ' where mcsil.company_site_id = mtpm.company_key '||
165: ' and mcsil.partner_type = 3'||
166: ' and mcsil.sr_instance_id = :v_sr_instance_id ) '||
167: ' and mtpm.map_type = 2';

Line 175: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

171: COMMIT;
172:
173: IF lv_msc_tp_coll_window = 0 THEN
174: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
175: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
176: END IF;
177:
178:
179: -- ======================================================================================

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

202: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
203:
204: -- ======================================================================================
205: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
206: -- These records will be found using msc_company_site_id_lid as reference.
207: -- ======================================================================================
208: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
209: ' where exists(select 1 '||
210: ' from msc_company_site_id_lid mcsil '||

Line 210: ' from msc_company_site_id_lid mcsil '||

206: -- These records will be found using msc_company_site_id_lid as reference.
207: -- ======================================================================================
208: lv_sql_stmt1 := ' delete msc_trading_partner_maps mtpm '||
209: ' where exists(select 1 '||
210: ' from msc_company_site_id_lid mcsil '||
211: ' where mcsil.company_site_id = mtpm.company_key '||
212: ' and mcsil.partner_type = 3'||
213: ' and mcsil.sr_instance_id = :v_sr_instance_id ) '||
214: ' and mtpm.map_type = 2';

Line 221: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

217:
218: COMMIT;
219: IF lv_msc_tp_coll_window = 0 THEN
220: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
221: DELETE MSC_COMPANY_SITE_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;
222: END IF;
223:
224: -- ======================================================================================
225: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".

Line 287: -- Populate msc_company_site_id_lid

283: LOG_MESSAGE('Creating new company sites');
284: CREATE_NEW_COMPANY_SITES;
285: COMMIT;
286:
287: -- Populate msc_company_site_id_lid
288: LOG_MESSAGE('Populating msc_company_site_id_lid');
289: POPULATE_COMPANY_SITE_ID_LID;
290: COMMIT;
291:

Line 288: LOG_MESSAGE('Populating msc_company_site_id_lid');

284: CREATE_NEW_COMPANY_SITES;
285: COMMIT;
286:
287: -- Populate msc_company_site_id_lid
288: LOG_MESSAGE('Populating msc_company_site_id_lid');
289: POPULATE_COMPANY_SITE_ID_LID;
290: COMMIT;
291:
292: -- Collect Company Information

Line 430: msc_company_site_id_lid mcsl,

426: CURSOR updCompanyNameRecords IS
427: SELECT mcs.company_id, mcs.company_site_id,
428: decode(mtps.partner_type,G_SUPPLIER, mtps.tp_site_code, G_CUSTOMER, mtps.LOCATION)
429: FROM msc_st_Trading_partner_sites mtps,
430: msc_company_site_id_lid mcsl,
431: msc_company_sites mcs --bug 5097405
432: WHERE mtps.sr_instance_id = mcsl.sr_instance_id
433: AND mtps.sr_instance_id = v_sr_instance_id
434: AND mtps.partner_type = mcsl.partner_type

Line 828: INSERT INTO MSC_COMPANY_SITE_ID_LID

824: LOG_MESSAGE('POPULATE_COMPANY_SITE_ID_LID started');
825:
826: BEGIN
827:
828: INSERT INTO MSC_COMPANY_SITE_ID_LID
829: ( SR_INSTANCE_ID,
830: SR_COMPANY_ID,
831: SR_COMPANY_SITE_ID,
832: PARTNER_TYPE,

Line 851: from msc_company_site_id_lid mcsil

847: and mst.partner_type = G_ORGANIZATION
848: and mcil.company_id = mcs.company_id
849: and mst.organization_code = mcs.company_site_name
850: and not exists (select 1
851: from msc_company_site_id_lid mcsil
852: where mcsil.sr_instance_id = mst.sr_instance_id
853: and mcsil.sr_company_id = nvl(mst.company_id, -1)
854: and mcsil.sr_company_site_id = mst.sr_tp_id
855: and mcsil.partner_type = mst.partner_type

Line 875: from msc_company_site_id_lid mcsil

871: and mcil.company_id = mcs.company_id
872: and decode(mtps.partner_type, 2, mtps.LOCATION,
873: 1, tp_site_code ) = mcs.company_site_name
874: and not exists (select 1
875: from msc_company_site_id_lid mcsil
876: where mcsil.sr_instance_id = mtps.sr_instance_id
877: and mcsil.sr_company_id = mtps.sr_tp_id
878: and mcsil.sr_company_site_id = mtps.sr_tp_site_id
879: and mcsil.partner_type = mtps.partner_type

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

883: LOG_MESSAGE('Error while POPULATing COMPANY_SITE_ID_LID');
884: LOG_MESSAGE('========================================');
885: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMPSITE_IDLID_ERR');
886: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_SITE_ID_LID');
887: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITE_ID_LID');
888: LOG_MESSAGE(FND_MESSAGE.GET);
889: LOG_MESSAGE(SQLERRM);
890:
891: END;

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

890:
891: END;
892: COMMIT;
893: --Bug 5155944: Analysing the table to improve performance
894: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITE_ID_LID');
895:
896: LOG_MESSAGE('Successfully populated MSC_COMPANY_SITE_ID_LID');
897:
898: END POPULATE_COMPANY_SITE_ID_LID;

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

892: COMMIT;
893: --Bug 5155944: Analysing the table to improve performance
894: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITE_ID_LID');
895:
896: LOG_MESSAGE('Successfully populated MSC_COMPANY_SITE_ID_LID');
897:
898: END POPULATE_COMPANY_SITE_ID_LID;
899:
900:

Line 1295: msc_company_site_id_lid mcsil

1291: mcil.company_id,
1292: mcsil.company_site_id
1293: from msc_st_item_suppliers msis,
1294: msc_company_id_lid mcil,
1295: msc_company_site_id_lid mcsil
1296: where msis.supplier_id = mcil.sr_company_id
1297: and msis.sr_instance_id = mcil.sr_instance_id
1298: and mcil.partner_type = G_SUPPLIER
1299: and msis.sr_instance_id = p_instance_id

Line 1329: msc_company_site_id_lid mcsil

1325: mcil.company_id,
1326: mcsil.company_site_id
1327: from msc_st_item_customers msic,
1328: msc_company_id_lid mcil,
1329: msc_company_site_id_lid mcsil
1330: where msic.customer_id = mcil.sr_company_id
1331: and msic.sr_instance_id = mcil.sr_instance_id
1332: and mcil.partner_type = G_CUSTOMER
1333: and msic.sr_instance_id = p_instance_id

Line 1424: msc_company_site_id_lid mcsil

1420: SELECT
1421: mcsil.COMPANY_SITE_ID,
1422: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')
1423: from msc_st_trading_partners mtp,
1424: msc_company_site_id_lid mcsil
1425: where nvl(mtp.company_id, -1) = mcsil.sr_company_id
1426: and mtp.sr_instance_id = mcsil.sr_instance_id
1427: and mtp.sr_instance_id = v_sr_instance_id
1428: and mtp.sr_tp_id = mcsil.sr_company_site_id

Line 1450: msc_company_site_id_lid mcsil

1446: mstps.county,
1447: mstps.province,
1448: mstps.postal_code
1449: FROM MSC_ST_TRADING_PARTNER_SITES mstps,
1450: msc_company_site_id_lid mcsil
1451: WHERE mcsil.SR_COMPANY_ID = nvl(mstps.sr_tp_id, -1)
1452: AND mcsil.SR_COMPANY_SITE_ID= mstps.SR_TP_SITE_ID
1453: AND mcsil.SR_INSTANCE_ID= mstps.SR_INSTANCE_ID
1454: AND mcsil.partner_type = mstps.partner_type

Line 1482: msc_company_site_id_lid mcsil

1478: mtps.county,
1479: mtps.province,
1480: mtps.postal_code
1481: from msc_st_trading_partner_sites mtps,
1482: msc_company_site_id_lid mcsil
1483: where nvl(mtps.company_id, -1) = mcsil.sr_company_id
1484: and mtps.sr_instance_id = mcsil.sr_instance_id
1485: and mtps.sr_instance_id = v_sr_instance_id
1486: and mtps.sr_tp_id = mcsil.sr_company_site_id

Line 1714: msc_company_site_id_lid mcsil,

1710: cursor newOrgMap is
1711: select DISTINCT mtp.partner_id,
1712: mcs.company_site_id
1713: from msc_company_sites mcs,
1714: msc_company_site_id_lid mcsil,
1715: msc_trading_partners mtp
1716: where mcs.company_site_id = mcsil.company_site_id
1717: -- Process for the current instance only
1718: and mcsil.sr_instance_id = p_instance_id

Line 1750: msc_company_site_id_lid mcsil,

1746: cursor newTpSIteMap is
1747: select DISTINCT mtsil.tp_site_id,
1748: mcs.company_site_id
1749: from msc_company_sites mcs,
1750: msc_company_site_id_lid mcsil,
1751: msc_tp_site_id_lid mtsil
1752: where mcs.company_site_id = mcsil.company_site_id
1753: and mcsil.sr_instance_id = p_instance_id
1754: and mcsil.sr_instance_id = mtsil.sr_instance_id