[Home] [Help]
View: CSC_HZ_PARTY_ACCOUNTS_V
View Text
SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, ROLES.PRIMARY_FLAG
, ROLES.ROLE_TYPE
, ACCT.CUST_ACCOUNT_ID
, ACCT.ACCOUNT_NUMBER
, ACCT.ACCOUNT_NAME
, ACCT.LAST_UPDATE_DATE
, PARTY.COUNTRY
, ACCT.STATUS
, ACCT.ACCOUNT_TERMINATION_DATE
, ACCT.ACCOUNT_ACTIVATION_DATE
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCT
, HZ_CUST_ACCOUNT_ROLES ROLES
WHERE ACCT.PARTY_ID = PARTY.PARTY_ID
AND ACCT.PARTY_ID = ROLES.PARTY_ID(+)
AND ACCT.CUST_ACCOUNT_ID = ROLES.CUST_ACCOUNT_ID(+)
Columns
Name |
ROW_ID |
PARTY_ID |
PARTY_NUMBER |
PARTY_NAME |
PARTY_TYPE |
PRIMARY_FLAG |
ROLE |
CUST_ACCOUNT_ID |
ACCOUNT_NUMBER |
ACCOUNT_NAME |
LAST_UPDATE_DATE |
COUNTRY |
STATUS |
ACCOUNT_TERMINATION_DATE |
ACCOUNT_ACTIVATION_DATE |