[Home] [Help]
View: AR_IDEP_COMMITMENT_USAGE
View Text
SELECT PARTY.ROWID
, TRX.CUSTOMER_TRX_ID
, PARTY.PARTY_ID
, PARTY.EMAIL_ADDRESS
, PARTY.PARTY_NAME
, REL.RELATIONSHIP_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('PARTY_RELATIONS_TYPE'
, REL.RELATIONSHIP_TYPE) RELATIONSHIP_MEANING
, REL.START_DATE
, REL.END_DATE
FROM HZ_PARTIES PARTY
, RA_CUSTOMER_TRX_ALL TRX
, HZ_RELATIONSHIPS REL
WHERE TRX.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.SUBJECT_TYPE IN ('PERSON'
, 'ORGANIZATION')
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_ID = TRX.CUSTOMER_TRX_ID
AND REL.OBJECT_TYPE = 'DEPOSIT'
AND REL.OBJECT_TABLE_NAME = 'RA_CUSTOMER_TRX_ALL'
AND REL.RELATIONSHIP_TYPE IN ('DOCUMENT_OWNER'
, 'DOCUMENT_USER')
Columns
Name |
ROW_ID |
CUSTOMER_TRX_ID |
PARTY_ID |
EMAIL_ADDRESS |
PARTY_NAME |
RELATIONSHIP_TYPE |
RELATIONSHIP_MEANING |
START_DATE |
END_DATE |