APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_COMPANIES

Line 2107: MSC_COMPANIES MC

2103: MSC_TP_ID_LID tils,
2104: MSC_TP_SITE_ID_LID tsilc,
2105: MSC_TP_SITE_ID_LID tsils,
2106: MSC_ST_TRADING_PARTNERS mst,
2107: MSC_COMPANIES MC
2108: WHERE mst.PARTNER_TYPE= 3
2109: /* SCE Change starts */
2110: AND nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = MC.company_name
2111: -- AND nvl( mst.company_id, -1) = -1 -- commented for aerox

Line 3770: MSC_COMPANIES MC

3766: SELECT decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, null, mc.company_id) company_id1,
3767: mst.partner_name partner_name,
3768: mst.partner_type partner_type
3769: from MSC_ST_TRADING_PARTNERS mst,
3770: MSC_COMPANIES MC
3771: where nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = mc.company_name
3772: and mst.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
3773: and mst.partner_type IN (1,2,4) --Vendor/Customer/Carrier
3774: /* SCE CHANGE STARTS */

Line 3791: MSC_COMPANIES MC

3787: Cursor c5_tpname IS
3788: SELECT distinct mst.Partner_Name, mst.sr_tp_id, mst.sr_instance_id, mst.Partner_Type,
3789: decode(mc.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID, -1, mc.company_id) company_id1
3790: FROM MSC_ST_TRADING_PARTNERS mst,
3791: MSC_COMPANIES MC
3792: WHERE EXISTS ( select 1
3793: from MSC_TRADING_PARTNERS mtp
3794: where mtp.sr_tp_id= mst.sr_tp_id
3795: and mtp.sr_instance_id= mst.sr_instance_id

Line 3929: msc_companies mc

3925: mtp.PARTNER_ID
3926: FROM MSC_ST_TRADING_PARTNERS mst,
3927: MSC_TRADING_PARTNERS mtp,
3928: /* SCE Change starts */
3929: msc_companies mc
3930: /* SCE Change ends */
3931: WHERE NOT EXISTS( select 1
3932: from MSC_TP_ID_LID mtil
3933: where mst.SR_TP_ID= mtil.SR_TP_ID

Line 3945: -- Add join with msc_companies

3941: AND mst.Partner_Type= mtp.Partner_Type
3942: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3943: AND mst.Partner_Type IN ( 1, 2)
3944: /* SCE Change starts */
3945: -- Add join with msc_companies
3946: AND nvl(mst.company_name, MSC_CL_COLLECTION.v_my_company_name) = mc.company_name
3947: AND mc.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID );
3948: -- AND nvl( mst.company_id, -1) = -1; -- commented for aerox
3949: /* SCE Change ends */

Line 4416: MSC_COMPANIES mc

4412: mst.AGGREGATE_DEMAND_FLAG,
4413: mst.CUST_ACCOUNT_NUMBER
4414: FROM MSC_ST_TRADING_PARTNERS mst,
4415: MSC_TRADING_PARTNERS mtp,
4416: MSC_COMPANIES mc
4417: WHERE NOT EXISTS( select 1
4418: from MSC_TP_ID_LID mtil
4419: where mst.SR_TP_ID= mtil.SR_TP_ID
4420: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID