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_ID_LID

Line 174: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

170:
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:

Line 220: DELETE MSC_COMPANY_ID_LID WHERE SR_INSTANCE_ID= p_instance_id;

216: EXECUTE IMMEDIATE lv_sql_stmt1 USING v_sr_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: -- ======================================================================================

Line 264: -- Populate msc_company_id_lid table with new Company information

260: p_last_collection_id );
261: COMMIT;
262:
263: -- ======================================================================================
264: -- Populate msc_company_id_lid table with new Company information
265: -- ======================================================================================
266:
267: LOG_MESSAGE('Populating msc_company_id_lid');
268: POPULATE_COMPANY_ID_LID;

Line 267: LOG_MESSAGE('Populating msc_company_id_lid');

263: -- ======================================================================================
264: -- Populate msc_company_id_lid table with new Company information
265: -- ======================================================================================
266:
267: LOG_MESSAGE('Populating msc_company_id_lid');
268: POPULATE_COMPANY_ID_LID;
269: COMMIT;
270:
271: -- ======================================================================================

Line 369: msc_company_id_lid mcil,

365: -- Cursor for changed company names
366: CURSOR updateCompanyNames IS
367: SELECT mc.company_id, mtps.company_name
368: FROM msc_st_trading_partners mtps,
369: msc_company_id_lid mcil,
370: msc_companies mc
371: WHERE mtps.sr_instance_id = v_sr_instance_id
372: AND mcil.sr_instance_id = mtps.sr_instance_id
373: AND mcil.partner_type = decode(mtps.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)

Line 541: -- Cursor for msc_company_id_lid

537: END CREATE_NEW_COMPANIES;
538:
539: PROCEDURE POPULATE_COMPANY_ID_LID IS
540:
541: -- Cursor for msc_company_id_lid
542: CURSOR newCompLidRecords IS
543: select distinct
544: mst.sr_instance_id sr_instance_id,
545: nvl(mst.company_id, -1) sr_company_id,

Line 559: from msc_company_id_lid mcil;

555: select mcil.sr_instance_id,
556: mcil.sr_company_id,
557: mcil.partner_type,
558: mcil.company_id
559: from msc_company_id_lid mcil;
560:
561: a_sr_instance_id number_arr;
562: a_sr_company_id number_arr;
563: a_partner_type number_arr;

Line 579: -- Populate msc_company_id_lid table

575: close newCompLidRecords;
576:
577:
578: LOG_MESSAGE('No. of company_id_lid records = '||a_sr_instance_id.COUNT);
579: -- Populate msc_company_id_lid table
580: -- Perform this step only if some data is fetched
581: BEGIN
582: IF a_sr_instance_id.COUNT > 0 THEN
583:

Line 585: insert into msc_company_id_lid

581: BEGIN
582: IF a_sr_instance_id.COUNT > 0 THEN
583:
584: FORALL i IN 1..a_sr_instance_id.COUNT
585: insert into msc_company_id_lid
586: ( sr_instance_id,
587: sr_company_id,
588: partner_type,
589: company_id

Line 599: LOG_MESSAGE('Error while uploading msc_company_id_lid table');

595: a_company_id(i)
596: );
597: END IF;
598: EXCEPTION WHEN OTHERS THEN
599: LOG_MESSAGE('Error while uploading msc_company_id_lid table');
600:
601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');

Line 604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');

600:
601: LOG_MESSAGE('========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_LID_ERR');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_COMPANY_ID_LID');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_ID_LID');
605: LOG_MESSAGE(FND_MESSAGE.GET);
606:
607: LOG_MESSAGE(SQLERRM);
608:

Line 616: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_ID_LID');

612:
613: -- Commit the transaction
614: COMMIT;
615: --Bug 5155944: Analysing the table to improve performance
616: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_ID_LID');
617:
618:
619: END POPULATE_COMPANY_ID_LID;
620:

Line 726: msc_company_id_lid mcil

722:
723: select mcil.company_id company_id,
724: mstp.LOCATION company_site_name
725: from msc_st_trading_partner_sites mstp,
726: msc_company_id_lid mcil
727: where
728: -- Make sure that the Trading partner is defined as Company
729: mstp.sr_tp_id = mcil.sr_company_id
730: and mstp.sr_instance_id = mcil.sr_instance_id

Line 744: msc_company_id_lid mcil

740: -- Add sites from msc_trading_partner_sites for Suppliers.
741: SELECT mcil.company_id company_id,
742: mstp.tp_site_code company_site_name
743: from msc_st_trading_partner_sites mstp,
744: msc_company_id_lid mcil
745: where
746: -- Make sure that the Trading partner is defined as Company
747: mstp.sr_tp_id = mcil.sr_company_id
748: and mstp.sr_instance_id = mcil.sr_instance_id

Line 841: msc_company_id_lid mcil,

837: mst.sr_tp_id sr_company_site_id,
838: mst.partner_type partner_type,
839: mcs.company_site_id
840: from msc_st_trading_partners mst,
841: msc_company_id_lid mcil,
842: msc_company_sites mcs
843: where nvl(mst.company_id, -1) = mcil.sr_company_id
844: and mst.sr_instance_id = mcil.sr_instance_id
845: and mst.partner_type = mcil.partner_type

Line 865: msc_company_id_lid mcil,

861: mtps.sr_tp_site_id sr_company_site_id,
862: mtps.partner_type,
863: mcs.company_site_id
864: from msc_st_trading_partner_sites mtps,
865: msc_company_id_lid mcil,
866: msc_company_sites mcs
867: where mtps.sr_instance_id = mcil.sr_instance_id
868: and mtps.sr_instance_id = v_sr_instance_id
869: and mtps.sr_tp_id = mcil.sr_company_id

Line 1282: msc_company_id_lid mcil

1278: select ROWIDTOCHAR(msis.rowid),
1279: mcil.company_id,
1280: -99
1281: from msc_st_item_suppliers msis,
1282: msc_company_id_lid mcil
1283: where msis.supplier_id = mcil.sr_company_id
1284: and msis.sr_instance_id = mcil.sr_instance_id
1285: and mcil.partner_type = G_SUPPLIER
1286: and msis.sr_instance_id = p_instance_id

Line 1294: msc_company_id_lid mcil,

1290: select ROWIDTOCHAR(msis.rowid),
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

Line 1316: msc_company_id_lid mcil

1312: select ROWIDTOCHAR(msic.rowid),
1313: mcil.company_id,
1314: -99
1315: from msc_st_item_customers msic,
1316: msc_company_id_lid mcil
1317: where msic.customer_id = mcil.sr_company_id
1318: and msic.sr_instance_id = mcil.sr_instance_id
1319: and mcil.partner_type = G_CUSTOMER
1320: and msic.sr_instance_id = p_instance_id

Line 1328: msc_company_id_lid mcil,

1324: select ROWIDTOCHAR(msic.rowid),
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

Line 1675: msc_company_id_lid mcil,

1671: select DISTINCT mtp.partner_id,
1672: mcr.relationship_id
1673: from msc_trading_partners mtp,
1674: msc_tp_id_lid mtil,
1675: msc_company_id_lid mcil,
1676: msc_company_relationships mcr
1677: where mtp.partner_id = mtil.tp_id
1678: and mtil.sr_instance_id = p_instance_id
1679: and mtil.sr_tp_id = mcil.sr_company_id

Line 2263: msc_company_id_lid mcil

2259: mscu.email_address email_address,
2260: mscu.fax fax
2261: from msc_st_company_users mscu,
2262: fnd_user fu,
2263: msc_company_id_lid mcil
2264: where mscu.sr_instance_id = p_sr_instance_id
2265: and UPPER(mscu.user_name) = fu.user_name
2266: and mscu.sr_company_id = mcil.sr_company_id
2267: and mscu.sr_instance_id = mcil.sr_instance_id

Line 2298: msc_company_id_lid mcil

2294: mscu.sr_instance_id sr_instance_id,
2295: mcil.company_id company_id
2296: from msc_st_company_users mscu,
2297: fnd_user fu,
2298: msc_company_id_lid mcil
2299: where mscu.sr_instance_id = p_sr_instance_id
2300: and UPPER(mscu.user_name) = fu.user_name
2301: and mscu.sr_company_id = mcil.sr_company_id
2302: and mscu.sr_instance_id = mcil.sr_instance_id