VIEW: APPS.AR_IDEP_COMMITMENT_USAGE

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')