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 2140: MSC_ST_TRADING_PARTNER_SITES msts

2136: msts.LOCATION,
2137: msts.LONGITUDE,
2138: msts.LATITUDE
2139: FROM MSC_TRADING_PARTNERS mtp,
2140: MSC_ST_TRADING_PARTNER_SITES msts
2141: WHERE msts.PARTNER_TYPE= 3
2142: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2143: AND mtp.SR_TP_ID= msts.SR_TP_ID
2144: AND mtp.PARTNER_TYPE= 3

Line 3738: MSC_ST_TRADING_PARTNER_SITES msts

3734: msts.SR_TP_SITE_ID,
3735: msts.SR_INSTANCE_ID,
3736: msts.SHIPPING_CONTROL
3737: FROM MSC_TP_SITE_ID_LID mtsil,
3738: MSC_ST_TRADING_PARTNER_SITES msts
3739: WHERE mtsil.SR_TP_SITE_ID= msts.SR_TP_SITE_ID
3740: AND mtsil.SR_INSTANCE_ID= msts.SR_INSTANCE_ID
3741: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3742: AND mtsil.Partner_Type= msts.Partner_Type

Line 3808: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3804:
3805:
3806: Cursor c6 IS
3807: SELECT distinct mtil.TP_ID, msts.tp_site_code
3808: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3809: MSC_TP_ID_LID mtil
3810: WHERE NOT EXISTS ( select 1
3811: from MSC_TRADING_PARTNER_SITES mtps
3812: where mtps.TP_Site_Code= msts.TP_Site_Code

Line 3832: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3828: mtil.TP_ID,
3829: msts.Operating_Unit_Name,
3830: msts.TP_Site_Code,
3831: msts.Location
3832: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3833: MSC_TP_ID_LID mtil
3834: WHERE NOT EXISTS ( select 1
3835: from MSC_TRADING_PARTNER_SITES mtps
3836: where NVL(mtps.Operating_Unit_Name, ' ')=

Line 3859: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3855: nvl(msts.company_id, -1) SR_COMPANY_ID,
3856: msts.SR_TP_SITE_ID,
3857: msts.SR_INSTANCE_ID,
3858: mtp.PARTNER_SITE_ID
3859: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3860: MSC_TP_ID_LID mtil,
3861: MSC_TRADING_PARTNER_SITES mtp
3862: WHERE NOT EXISTS( select 1
3863: from MSC_TP_SITE_ID_LID mtsil

Line 3891: FROM MSC_ST_TRADING_PARTNER_SITES msts,

3887: /* SCE Change ends*/
3888: msts.SR_TP_SITE_ID,
3889: msts.SR_INSTANCE_ID,
3890: mtp.PARTNER_SITE_ID
3891: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3892: MSC_TP_ID_LID mtil,
3893: MSC_TRADING_PARTNER_SITES mtp
3894: WHERE NOT EXISTS( select 1
3895: from MSC_TP_SITE_ID_LID mtsil

Line 4636: FROM MSC_ST_TRADING_PARTNER_SITES msts,

4632: 1,
4633: msts.location_id,
4634: msts.operating_unit,
4635: mtp.PARTNER_SITE_ID
4636: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4637: MSC_TP_ID_LID mtil,
4638: MSC_TRADING_PARTNER_SITES mtp
4639: WHERE NOT EXISTS( select 1
4640: from MSC_TP_SITE_ID_LID mtsil

Line 4857: FROM MSC_ST_TRADING_PARTNER_SITES msts,

4853: 2,
4854: msts.location_id,
4855: mtp.PARTNER_SITE_ID,
4856: msts.SR_TP_ID
4857: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4858: MSC_TP_ID_LID mtil,
4859: MSC_TRADING_PARTNER_SITES mtp
4860: WHERE NOT EXISTS( select 1
4861: from MSC_TP_SITE_ID_LID mtsil