View: QP_CUSTOMERS_V

Product:	QP - Advanced Pricing
Description:	This view is for segment SOLD_TO_ORG_ID in customer context for "Qualifiers Contexts" flexfield
Implementation/DBA Data:	APPS.QP_CUSTOMERS_V

View Text

SELECT /*+ FIRST_ROWS */ PARTY.PARTY_NAME
, ACCT.ACCOUNT_NUMBER||' CUSTOMER'
, ACCT.CUST_ACCOUNT_ID
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCT
WHERE PARTY.PARTY_ID = ACCT.PARTY_ID
AND ACCT.STATUS = 'A'

Columns