VIEW: APPS.IEX_REPOSSESSIONS_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', 'REPOSSESSION') status, rps.disposition_code disposition_code, iex_utilities.get_lookup_meaning('IEX_REPO_DISPOSITION', rps.DISPOSITION_CODE) disposition, rps.repossession_id repossession_id, dl.case_id case_id, rps.repossession_date repossession_date, rps.last_update_date last_update_date, rps.contract_id contract_id, rps.contract_number contract_number FROM iex_delinquencies dl, iex_repossessions rps,ra_customer_trx rtx WHERE dl.delinquency_id = rps.delinquency_id and rps.delinquency_id is not null and rtx.customer_trx_id = dl.transaction_id and rps.contract_id is null and rps.contract_number is null UNION ALL select rpss.party_id party_id, rpss.cust_account_id cust_account_id, to_number(rpss.customer_site_use_id) bill_to_site_use_id, rpss.delinquency_id delinquency_id, null transaction_id, null transaction_number, iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', 'REPOSSESSION') status, rpss.disposition_code disposition_code, iex_utilities.get_lookup_meaning('IEX_REPO_DISPOSITION', rpss.DISPOSITION_CODE) disposition, rpss.repossession_id repossession_id, null case_id, rpss.repossession_date repossession_date, rpss.last_update_date last_update_date, rpss.contract_id contract_id, rpss.contract_number contract_number from iex_repossessions rpss WHERE rpss.contract_id is not null and rpss.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'
, 'REPOSSESSION') STATUS
, RPS.DISPOSITION_CODE DISPOSITION_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_REPO_DISPOSITION'
, RPS.DISPOSITION_CODE) DISPOSITION
, RPS.REPOSSESSION_ID REPOSSESSION_ID
, DL.CASE_ID CASE_ID
, RPS.REPOSSESSION_DATE REPOSSESSION_DATE
, RPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPS.CONTRACT_ID CONTRACT_ID
, RPS.CONTRACT_NUMBER CONTRACT_NUMBER
FROM IEX_DELINQUENCIES DL
, IEX_REPOSSESSIONS RPS
, RA_CUSTOMER_TRX RTX
WHERE DL.DELINQUENCY_ID = RPS.DELINQUENCY_ID
AND RPS.DELINQUENCY_ID IS NOT NULL
AND RTX.CUSTOMER_TRX_ID = DL.TRANSACTION_ID
AND RPS.CONTRACT_ID IS NULL
AND RPS.CONTRACT_NUMBER IS NULL UNION ALL SELECT RPSS.PARTY_ID PARTY_ID
, RPSS.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, TO_NUMBER(RPSS.CUSTOMER_SITE_USE_ID) BILL_TO_SITE_USE_ID
, RPSS.DELINQUENCY_ID DELINQUENCY_ID
, NULL TRANSACTION_ID
, NULL TRANSACTION_NUMBER
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'REPOSSESSION') STATUS
, RPSS.DISPOSITION_CODE DISPOSITION_CODE
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_REPO_DISPOSITION'
, RPSS.DISPOSITION_CODE) DISPOSITION
, RPSS.REPOSSESSION_ID REPOSSESSION_ID
, NULL CASE_ID
, RPSS.REPOSSESSION_DATE REPOSSESSION_DATE
, RPSS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPSS.CONTRACT_ID CONTRACT_ID
, RPSS.CONTRACT_NUMBER CONTRACT_NUMBER
FROM IEX_REPOSSESSIONS RPSS
WHERE RPSS.CONTRACT_ID IS NOT NULL
AND RPSS.CONTRACT_NUMBER IS NOT NULL