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_LOCATION_ASSOCIATIONS

Line 2164: MSC_ST_LOCATION_ASSOCIATIONS msta

2160: msta.organization_id,
2161: msta.SR_INSTANCE_ID
2162: FROM MSC_TP_ID_LID til,
2163: MSC_TP_SITE_ID_LID tsil,
2164: MSC_ST_LOCATION_ASSOCIATIONS msta
2165: WHERE til.SR_INSTANCE_ID= msta.SR_INSTANCE_ID
2166: AND til.SR_TP_ID= msta.SR_TP_ID
2167: AND til.PARTNER_TYPE= msta.PARTNER_TYPE
2168: AND tsil.SR_INSTANCE_ID= msta.SR_INSTANCE_ID

Line 2215: MSC_ST_LOCATION_ASSOCIATIONS msta

2211: msta.SR_TP_ID ORGANIZATION_ID,
2212: msta.LOCATION_ID PARTNER_SITE_ID,
2213: msta.SR_INSTANCE_ID
2214: FROM MSC_TRADING_PARTNERS mtps,
2215: MSC_ST_LOCATION_ASSOCIATIONS msta
2216: WHERE msta.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2217: AND msta.partner_type = 3
2218: AND msta.SR_INSTANCE_ID= mtps.SR_INSTANCE_ID
2219: AND msta.SR_TP_ID= mtps.SR_TP_ID