VIEW: APPS.GMD_CUST_VEND_MST_V2

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)