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_SETUP_ODS_LOAD dependencies on MSC_ST_TRADING_PARTNER_SITES

Line 2146: MSC_ST_TRADING_PARTNER_SITES msts

2142: msts.LOCATION,
2143: msts.LONGITUDE,
2144: msts.LATITUDE
2145: FROM MSC_TRADING_PARTNERS mtp,
2146: MSC_ST_TRADING_PARTNER_SITES msts
2147: WHERE msts.PARTNER_TYPE= 3
2148: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2149: AND mtp.SR_TP_ID= msts.SR_TP_ID
2150: AND mtp.PARTNER_TYPE= 3

Line 3748: MSC_ST_TRADING_PARTNER_SITES msts

3744: msts.SR_TP_SITE_ID,
3745: msts.SR_INSTANCE_ID,
3746: msts.SHIPPING_CONTROL
3747: FROM MSC_TP_SITE_ID_LID mtsil,
3748: MSC_ST_TRADING_PARTNER_SITES msts
3749: WHERE mtsil.SR_TP_SITE_ID= msts.SR_TP_SITE_ID
3750: AND mtsil.SR_INSTANCE_ID= msts.SR_INSTANCE_ID
3751: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3752: AND mtsil.Partner_Type= msts.Partner_Type

Line 3818: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3814:
3815:
3816: Cursor c6 IS
3817: SELECT distinct mtil.TP_ID, msts.tp_site_code
3818: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3819: MSC_TP_ID_LID mtil
3820: WHERE NOT EXISTS ( select 1
3821: from MSC_TRADING_PARTNER_SITES mtps
3822: where mtps.TP_Site_Code= msts.TP_Site_Code

Line 3842: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3838: mtil.TP_ID,
3839: msts.Operating_Unit_Name,
3840: msts.TP_Site_Code,
3841: msts.Location
3842: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3843: MSC_TP_ID_LID mtil
3844: WHERE NOT EXISTS ( select 1
3845: from MSC_TRADING_PARTNER_SITES mtps
3846: where NVL(mtps.Operating_Unit_Name, ' ')=

Line 3869: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3865: nvl(msts.company_id, -1) SR_COMPANY_ID,
3866: msts.SR_TP_SITE_ID,
3867: msts.SR_INSTANCE_ID,
3868: mtp.PARTNER_SITE_ID
3869: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3870: MSC_TP_ID_LID mtil,
3871: MSC_TRADING_PARTNER_SITES mtp
3872: WHERE NOT EXISTS( select 1
3873: from MSC_TP_SITE_ID_LID mtsil

Line 3901: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3897: /* SCE Change ends*/
3898: msts.SR_TP_SITE_ID,
3899: msts.SR_INSTANCE_ID,
3900: mtp.PARTNER_SITE_ID
3901: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3902: MSC_TP_ID_LID mtil,
3903: MSC_TRADING_PARTNER_SITES mtp
3904: WHERE NOT EXISTS( select 1
3905: from MSC_TP_SITE_ID_LID mtsil

Line 4646: FROM MSC_ST_TRADING_PARTNER_SITES msts,

4642: 1,
4643: msts.location_id,
4644: msts.operating_unit,
4645: mtp.PARTNER_SITE_ID
4646: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4647: MSC_TP_ID_LID mtil,
4648: MSC_TRADING_PARTNER_SITES mtp
4649: WHERE NOT EXISTS( select 1
4650: from MSC_TP_SITE_ID_LID mtsil

Line 4867: FROM MSC_ST_TRADING_PARTNER_SITES msts,

4863: 2,
4864: msts.location_id,
4865: mtp.PARTNER_SITE_ID,
4866: msts.SR_TP_ID
4867: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4868: MSC_TP_ID_LID mtil,
4869: MSC_TRADING_PARTNER_SITES mtp
4870: WHERE NOT EXISTS( select 1
4871: from MSC_TP_SITE_ID_LID mtsil