APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ST_TRADING_PARTNERS

Line 2112: MSC_ST_TRADING_PARTNERS mst,

2108: FROM MSC_TP_ID_LID tilc,
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

Line 3721: MSC_ST_TRADING_PARTNERS mst

3717: mst.PROJECT_CONTROL_LEVEL,
3718: mst.CUSTOMER_CLASS_CODE,
3719: mst.CUSTOMER_TYPE
3720: FROM MSC_TP_ID_LID mtil,
3721: MSC_ST_TRADING_PARTNERS mst
3722: WHERE mtil.SR_TP_ID= mst.SR_TP_ID
3723: AND mtil.SR_INSTANCE_ID= mst.SR_INSTANCE_ID
3724: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3725: AND mtil.Partner_Type= mst.Partner_Type

Line 3763: FROM MSC_ST_TRADING_PARTNERS mst

3759:
3760: /*
3761: Cursor c5 IS
3762: SELECT distinct mst.Partner_Name, mst.Partner_Type
3763: FROM MSC_ST_TRADING_PARTNERS mst
3764: WHERE NOT EXISTS ( select 1
3765: from MSC_TRADING_PARTNERS mtp
3766: where mtp.Partner_Name= mst.Partner_Name
3767: and mtp.Partner_Type= mst.Partner_Type)

Line 3779: from MSC_ST_TRADING_PARTNERS mst,

3775: Cursor c5 IS
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

Line 3800: FROM MSC_ST_TRADING_PARTNERS mst,

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

Line 3936: FROM MSC_ST_TRADING_PARTNERS mst,

3932: mst.SR_TP_ID,
3933: mst.SR_INSTANCE_ID,
3934: mst.Partner_Type,
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 */

Line 3965: From msc_st_trading_partners

3961:
3962: -- ============ Cursor for UPDATE MSC_TP_ID_LID SRP Changes ==================== --
3963: CURSOR c13 IS
3964: Select resource_type, sr_instance_id , partner_type,sr_tp_id
3965: From msc_st_trading_partners
3966: Where sr_instance_id = MSC_CL_COLLECTION.v_instance_id
3967: And partner_type=2;
3968:
3969: lv_control_flag NUMBER;

Line 4424: FROM MSC_ST_TRADING_PARTNERS mst,

4420: mst.Partner_Type,
4421: mtp.PARTNER_ID,
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