[Home] [Help]
View: AST_ACCOUNT_PARTIES_V
Product: | AST - TeleSales |
Description: | AST_ACCOUNT_PARTIES_V retrieves limited party details for a customer account. |
Implementation/DBA Data: |
APPS.AST_ACCOUNT_PARTIES_V
|
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
, CUST_ACCOUNT.LAST_UPDATE_DATE
, CUST_ACCOUNT.LAST_UPDATED_BY
, CUST_ACCOUNT.CREATION_DATE
, CUST_ACCOUNT.CREATED_BY
, CUST_ACCOUNT.LAST_UPDATE_LOGIN
FROM HZ_CUST_ACCOUNTS CUST_ACCOUNT
, HZ_PARTIES 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 |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |