[Home] [Help]
View: 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 |