FND Design Data [Home] [Help]

View: JAI_CMN_CUSTOMERS_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.JAI_CMN_CUSTOMERS_V
View Text

SELECT C.CUST_ACCOUNT_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, PARTY_NAME PARTY_NAME
FROM HZ_PARTIES P
, HZ_CUST_ACCOUNTS C
WHERE P.PARTY_ID = C.PARTY_ID
AND EXISTS ( SELECT 1
FROM JAI_CMN_CUS_ADDRESSES
WHERE CUSTOMER_ID = C.CUST_ACCOUNT_ID )

Columns

Name
PARTY_ID
PARTY_NUMBER
PARTY_NAME