VIEW: APPS.IEX_LITIGATIONS_BALI_V

Source

View Text - Preformatted

SELECT dl.party_cust_id party_id, dl.cust_account_id cust_account_id, rtx.bill_to_site_use_id bill_to_site_use_id, dl.delinquency_id delinquency_id, dl.transaction_id transaction_id, rtx.trx_number transaction_number, iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'LITIGATION') status, lit.disposition_code disposition_code, iex_utilities.get_lookup_meaning('IEX_LTG_DISPOSITION', lit.disposition_code) disposition, lit.litigation_id litigation_id, dl.case_id case_id, lit.judgement_date judgement_date, lit.last_update_date last_update_date, lit.contract_id contract_id, lit.contract_number contract_number FROM iex_delinquencies dl, iex_litigations lit, ra_customer_trx rtx WHERE dl.delinquency_id = lit.delinquency_id AND lit.delinquency_id IS NOT NULL AND rtx.customer_trx_id = dl.transaction_id AND lit.contract_id IS NULL AND lit.contract_number IS NULL UNION ALL SELECT litt.party_id party_id, litt.cust_account_id cust_account_id, to_number(litt.customer_site_use_id) bill_to_site_use_id, NULL delinquency_id, NULL transaction_id, NULL transaction_number, iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'LITIGATION') status, litt.disposition_code disposition_code, iex_utilities.get_lookup_meaning('IEX_LTG_DISPOSITION', litt.disposition_code) disposition, litt.litigation_id litigation_id, NULL case_id, litt.judgement_date judgement_date, litt.last_update_date last_update_date, litt.contract_id contract_id, litt.contract_number contract_number FROM iex_litigations litt WHERE litt.contract_id IS NOT NULL AND litt.contract_number IS NOT NULL

View Text - HTML Formatted

SELECT DL.PARTY_CUST_ID PARTY_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, RTX.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, RTX.TRX_NUMBER TRANSACTION_NUMBER
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'LITIGATION') STATUS
, LIT.DISPOSITION_CODE DISPOSITION_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_LTG_DISPOSITION'
, LIT.DISPOSITION_CODE) DISPOSITION
, LIT.LITIGATION_ID LITIGATION_ID
, DL.CASE_ID CASE_ID
, LIT.JUDGEMENT_DATE JUDGEMENT_DATE
, LIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LIT.CONTRACT_ID CONTRACT_ID
, LIT.CONTRACT_NUMBER CONTRACT_NUMBER
FROM IEX_DELINQUENCIES DL
, IEX_LITIGATIONS LIT
, RA_CUSTOMER_TRX RTX
WHERE DL.DELINQUENCY_ID = LIT.DELINQUENCY_ID
AND LIT.DELINQUENCY_ID IS NOT NULL
AND RTX.CUSTOMER_TRX_ID = DL.TRANSACTION_ID
AND LIT.CONTRACT_ID IS NULL
AND LIT.CONTRACT_NUMBER IS NULL UNION ALL SELECT LITT.PARTY_ID PARTY_ID
, LITT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, TO_NUMBER(LITT.CUSTOMER_SITE_USE_ID) BILL_TO_SITE_USE_ID
, NULL DELINQUENCY_ID
, NULL TRANSACTION_ID
, NULL TRANSACTION_NUMBER
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'LITIGATION') STATUS
, LITT.DISPOSITION_CODE DISPOSITION_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_LTG_DISPOSITION'
, LITT.DISPOSITION_CODE) DISPOSITION
, LITT.LITIGATION_ID LITIGATION_ID
, NULL CASE_ID
, LITT.JUDGEMENT_DATE JUDGEMENT_DATE
, LITT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LITT.CONTRACT_ID CONTRACT_ID
, LITT.CONTRACT_NUMBER CONTRACT_NUMBER
FROM IEX_LITIGATIONS LITT
WHERE LITT.CONTRACT_ID IS NOT NULL
AND LITT.CONTRACT_NUMBER IS NOT NULL