Skip to content FND Design Data [Home] [Help]

View: XNC_ACCOUNT_PARTIES_V

Product: XNC - Sales for Communications (Obsolete)
Description: XNC_ACCOUNT_PARTIES_V retrieves limited party details for a customer account.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT CUST_ACCOUNT.ROWID
, CUST_ACCOUNT.CUST_ACCOUNT_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
FROM JTF_CUST_ACCOUNTS_V CUST_ACCOUNT
, ASO_I_PARTIES_V PARTY
WHERE CUST_ACCOUNT.PARTY_ID = PARTY.PARTY_ID

Columns

Name
ROW_ID
CUST_ACCOUNT_ID
PARTY_ID
PARTY_NAME
PARTY_TYPE
FIRST_NAME
MIDDLE_NAME
LAST_NAME