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.

VIEW: APPS.MSC_CUST_SUP_ORG_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)