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.

[Home] [Help]

View: MSC_LOCATIONS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_LOCATIONS_V

View Text

SELECT DISTINCT TPS.SR_TP_SITE_ID
, MSC_GET_NAME.ORG_CODE(ISM.FROM_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID)
, TPS.LOCATION
, ISM.FROM_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID
, TPS1.SR_TP_SITE_ID
, MSC_GET_NAME.ORG_CODE(ISM.TO_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID2)
, TPS1.LOCATION
, ISM.TO_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID2
FROM MSC_INTERORG_SHIP_METHODS ISM
, MSC_TRADING_PARTNER_SITES TPS
, MSC_TRADING_PARTNER_SITES TPS1
WHERE ISM.PLAN_ID =-1
AND ISM.SR_INSTANCE_ID = TPS.SR_INSTANCE_ID
AND ISM.SR_INSTANCE_ID2 = TPS1.SR_INSTANCE_ID
AND ISM.FROM_ORGANIZATION_ID = TPS.SR_TP_ID
AND ISM.TO_ORGANIZATION_ID = TPS1.SR_TP_ID
AND TPS.PARTNER_TYPE=3
AND TPS1.PARTNER_TYPE=3

Columns

Name
FROM_LOCATION_ID
FROM_LOCATION
FROM_LOCATION_DESC
FROM_ORGANIZATION_ID
SR_INSTANCE_ID
TO_LOCATION_ID
TO_LOCATION
TO_LOCATION_DESC
TO_ORGANIZATION_ID
SR_INSTANCE_ID2