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_CUST_SUP_ORG_V

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

View Text

SELECT PT.SR_TP_ID
, PT.SR_INSTANCE_ID
, PT.ORGANIZATION_CODE
, PT.MODELED_CUSTOMER_ID
, PT1.PARTNER_NAME
, PT.MODELED_CUSTOMER_SITE_ID
, PTS1.PARTNER_ADDRESS
, PT.MODELED_SUPPLIER_ID
, PT2.PARTNER_NAME
, PT.MODELED_SUPPLIER_SITE_ID
, PTS2.TP_SITE_CODE
FROM MSC_TRADING_PARTNERS PT
, MSC_TRADING_PARTNERS PT1
, MSC_TRADING_PARTNER_SITES PTS1
, MSC_TRADING_PARTNERS PT2
, MSC_TRADING_PARTNER_SITES PTS2
WHERE ( PT.MODELED_CUSTOMER_ID IS NOT NULL OR PT.MODELED_SUPPLIER_ID IS NOT NULL)
AND PT.MODELED_CUSTOMER_ID = PT1.PARTNER_ID (+)
AND PT.MODELED_SUPPLIER_ID = PT2.PARTNER_ID (+)
AND PT.MODELED_CUSTOMER_SITE_ID = PTS1.PARTNER_SITE_ID (+)
AND PT.MODELED_SUPPLIER_SITE_ID = PTS2.PARTNER_SITE_ID (+)

Columns

Name
ORGANIZATION_ID
SR_INSTANCE_ID
ORGANIZATION_CODE
CUSTOMER_ID
CUSTOMER_NAME
SHIP_TO_SITE_ID
SHIP_TO_ADDRESS
SUPPLIER_ID
SUPPLIER_NAME
SUPPLIER_SITE_ID
SUPPLIER_SITE