View: MRP_CUST_SUP_ORG_V

Product:	MRP - Master Scheduling/MRP
Description:	Customer and Supplier Organizations View
Implementation/DBA Data:	APPS.MRP_CUST_SUP_ORG_V

View Text

SELECT HR.ORGANIZATION_ID
, PARA.ORGANIZATION_CODE
, HR.ORG_INFORMATION1
, RA.CUSTOMER_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
, RA_CUSTOMERS_VIEW RA
, RA_SITE_USES SU
, RA_ADDRESSES A
, MTL_PARAMETERS PARA
, HR_ORGANIZATION_INFORMATION_V HR
WHERE PARA.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND RA.CUSTOMER_ID (+) = HR.ORG_INFORMATION1
AND SU.SITE_USE_ID (+) = HR.ORG_INFORMATION2
AND SU.ADDRESS_ID = A.ADDRESS_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)

Columns