[Home] [Help]
View: JAI_CUSTOMERS_V
Product: | JA - Asia/Pacific Localizations |
Description: | OFI customer views |
Implementation/DBA Data: |
APPS.JAI_CUSTOMERS_V
|
View Text
SELECT CUST_ACCT.CUST_ACCOUNT_ID
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, NVL(CUST_ACCT.STATUS
, 'A')
, PARTY.PARTY_ID
, PARTY.PARTY_TYPE
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
Columns
Name |
CUSTOMER_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
STATUS |
PARTY_ID |
PARTY_TYPE |