View: GMD_CUST_VEND_MST_V2

Product:	GMD - Process Manufacturing Product Development
Description:	View of customer and vendors for value set of Customer/Vendor Test Result report
Implementation/DBA Data:	APPS.GMD_CUST_VEND_MST_V2

View Text

SELECT DISTINCT HZCA.ACCOUNT_NUMBER CUST_VEND_NO
, HZP.PARTY_NAME CUST_VEND_NAME
, HZCA.CUST_ACCOUNT_ID CUST_VEND_ID
, '0' REPORT_TYPE
FROM HR_OPERATING_UNITS OU
, HZ_CUST_ACCT_SITES_ALL CASA
, HZ_CUST_SITE_USES_ALL CSUA
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS_ALL HZCA
WHERE OU.ORGANIZATION_ID = CSUA.ORG_ID
AND CASA.CUST_ACCT_SITE_ID = CSUA.CUST_ACCT_SITE_ID
AND CASA.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID
AND CASA.ORG_ID = CSUA.ORG_ID
AND HZP.PARTY_ID = HZCA.PARTY_ID UNION SELECT V.SEGMENT1 CUST_VEND_NO
, V.VENDOR_NAME CUST_VEND_NAME
, V.VENDOR_ID CUST_VEND_ID
, '1' REPORT_TYPE
FROM PO_VENDORS V
WHERE V.ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(V.START_DATE_ACTIVE
, SYSDATE - 1)
AND NVL(V.END_DATE_ACTIVE
, SYSDATE + 1)

Columns