APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_COMPANIES

Line 2113: MSC_COMPANIES MC

2109: MSC_TP_ID_LID tils,
2110: MSC_TP_SITE_ID_LID tsilc,
2111: MSC_TP_SITE_ID_LID tsils,
2112: MSC_ST_TRADING_PARTNERS mst,
2113: MSC_COMPANIES MC
2114: WHERE mst.PARTNER_TYPE= 3
2115: /* SCE Change starts */
2116: AND nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = MC.company_name
2117: -- AND nvl( mst.company_id, -1) = -1 -- commented for aerox

Line 3780: MSC_COMPANIES MC

3776: SELECT decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, null, mc.company_id) company_id1,
3777: mst.partner_name partner_name,
3778: mst.partner_type partner_type
3779: from MSC_ST_TRADING_PARTNERS mst,
3780: MSC_COMPANIES MC
3781: where nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = mc.company_name
3782: and mst.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
3783: and mst.partner_type IN (1,2,4) --Vendor/Customer/Carrier
3784: /* SCE CHANGE STARTS */

Line 3801: MSC_COMPANIES MC

3797: Cursor c5_tpname IS
3798: SELECT distinct mst.Partner_Name, mst.sr_tp_id, mst.sr_instance_id, mst.Partner_Type,
3799: decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, -1, mc.company_id) company_id1
3800: FROM MSC_ST_TRADING_PARTNERS mst,
3801: MSC_COMPANIES MC
3802: WHERE EXISTS ( select 1
3803: from MSC_TRADING_PARTNERS mtp
3804: where mtp.sr_tp_id= mst.sr_tp_id
3805: and mtp.sr_instance_id= mst.sr_instance_id

Line 3939: msc_companies mc

3935: mtp.PARTNER_ID
3936: FROM MSC_ST_TRADING_PARTNERS mst,
3937: MSC_TRADING_PARTNERS mtp,
3938: /* SCE Change starts */
3939: msc_companies mc
3940: /* SCE Change ends */
3941: WHERE NOT EXISTS( select 1
3942: from MSC_TP_ID_LID mtil
3943: where mst.SR_TP_ID= mtil.SR_TP_ID

Line 3955: -- Add join with msc_companies

3951: AND mst.Partner_Type= mtp.Partner_Type
3952: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3953: AND mst.Partner_Type IN ( 1, 2)
3954: /* SCE Change starts */
3955: -- Add join with msc_companies
3956: AND nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = mc.company_name
3957: AND mc.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID );
3958: -- AND nvl( mst.company_id, -1) = -1; -- commented for aerox
3959: /* SCE Change ends */

Line 4426: MSC_COMPANIES mc

4422: mst.AGGREGATE_DEMAND_FLAG,
4423: mst.CUST_ACCOUNT_NUMBER
4424: FROM MSC_ST_TRADING_PARTNERS mst,
4425: MSC_TRADING_PARTNERS mtp,
4426: MSC_COMPANIES mc
4427: WHERE NOT EXISTS( select 1
4428: from MSC_TP_ID_LID mtil
4429: where mst.SR_TP_ID= mtil.SR_TP_ID
4430: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID