[Home] [Help]
VIEW: APPS.QP_CUSTOMERS_V
Source
View Text - Preformatted
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'
View Text - HTML Formatted
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'