View: AR_IDEP_COMMITMENT_USAGE

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.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