View: QA_CUSTOMERS_LOV_V

Product:	QA - Quality
Description:	Customer collection element LOV validation view.
Implementation/DBA Data:	APPS.QA_CUSTOMERS_LOV_V

View Text

SELECT CUST_ACCT.CUST_ACCOUNT_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, CUST_ACCT.STATUS
, 'CUSTOMER'
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID

Columns