[Home] [Help]
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
Name |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_ID |