VIEW: APPS.MRP_CUST_SUP_ORG_V

Source

View Text - Preformatted

SELECT HR.ORGANIZATION_ID , PARA.ORGANIZATION_CODE , HR.ORG_INFORMATION1 , PART.PARTY_NAME , HR.ORG_INFORMATION2 , A.ADDRESS1 , HR.ORG_INFORMATION3 , PO.VENDOR_NAME , HR.ORG_INFORMATION4 , POS.VENDOR_SITE_CODE FROM PO_VENDORS PO, PO_VENDOR_SITES_ALL POS, HZ_CUST_ACCOUNTS RA, HZ_PARTIES PART, HZ_PARTY_SITES PS1, HZ_CUST_ACCT_SITES AS1, HZ_CUST_SITE_USES_ALL SU, HZ_LOCATIONS A, MTL_PARAMETERS PARA, HR_ORGANIZATION_INFORMATION_V HR WHERE PARA.ORGANIZATION_ID = HR.ORGANIZATION_ID AND RA.CUST_ACCOUNT_ID (+) = HR.ORG_INFORMATION1 AND SU.SITE_USE_ID (+) = HR.ORG_INFORMATION2 AND SU.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID(+) AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID(+) AND PS1.LOCATION_ID = A.LOCATION_ID(+) AND PO.VENDOR_ID (+) = HR.ORG_INFORMATION3 AND POS.VENDOR_SITE_ID (+) = HR.ORG_INFORMATION4 AND HR.ORG_INFORMATION_CONTEXT='Customer/Supplier Association' AND (HR.ORG_INFORMATION1 IS NOT NULL OR HR.ORG_INFORMATION3 IS NOT NULL) and RA.PARTY_ID = part.PARTY_ID(+)

View Text - HTML Formatted

SELECT HR.ORGANIZATION_ID
, PARA.ORGANIZATION_CODE
, HR.ORG_INFORMATION1
, PART.PARTY_NAME
, HR.ORG_INFORMATION2
, A.ADDRESS1
, HR.ORG_INFORMATION3
, PO.VENDOR_NAME
, HR.ORG_INFORMATION4
, POS.VENDOR_SITE_CODE
FROM PO_VENDORS PO
, PO_VENDOR_SITES_ALL POS
, HZ_CUST_ACCOUNTS RA
, HZ_PARTIES PART
, HZ_PARTY_SITES PS1
, HZ_CUST_ACCT_SITES AS1
, HZ_CUST_SITE_USES_ALL SU
, HZ_LOCATIONS A
, MTL_PARAMETERS PARA
, HR_ORGANIZATION_INFORMATION_V HR
WHERE PARA.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND RA.CUST_ACCOUNT_ID (+) = HR.ORG_INFORMATION1
AND SU.SITE_USE_ID (+) = HR.ORG_INFORMATION2
AND SU.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID(+)
AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID(+)
AND PS1.LOCATION_ID = A.LOCATION_ID(+)
AND PO.VENDOR_ID (+) = HR.ORG_INFORMATION3
AND POS.VENDOR_SITE_ID (+) = HR.ORG_INFORMATION4
AND HR.ORG_INFORMATION_CONTEXT='CUSTOMER/SUPPLIER ASSOCIATION'
AND (HR.ORG_INFORMATION1 IS NOT NULL OR HR.ORG_INFORMATION3 IS NOT NULL)
AND RA.PARTY_ID = PART.PARTY_ID(+)