VIEW: APPS.IEX_WRITEOFF_INVOICES_V

Source

View Text - Preformatted

SELECT distinct OKC.CONTRACT_NUMBER, IWO.CONTRACT_ID, IWO.CONS_INVOICE_ID, HDR.CONSOLIDATED_INVOICE_NUMBER, IWO.CONS_INVOICE_LINE_ID, ps.customer_trx_id, IWO.TRANSACTION_ID, ps.invoice_currency_code, Ps.AMOUNT_DUE_ORIGINAL, Ps.AMOUNT_APPLIED, PS.AMOUNT_DUE_REMAINING, ICO.CAS_ID, DEL.DELINQUENCY_ID, IWO.RECEVIABLES_ADJUSTMENT_ID, LOOKUP.MEANING, IWO.WRITEOFF_OBJECT_ID, IWO.WRITEOFF_ID, ADJUSTMENT_AMOUNT, LOOKUP1.MEANING, IWO.REQUEST_ID, IWO.writeoff_type, IWO.writeoff_type_id, IWO.writeoff_status ,SM.NAME FROM OKL_CNSLD_AR_HDRS_B HDR, OKL_CNSLD_AR_STRMS_B STREAM, OKC_K_HEADERS_B OKC, IEX_DELINQUENCIES DEL, IEX_CASE_OBJECTS ICO, IEX_WRITEOFF_OBJECTS IWO ,AR_LOOKUPS LOOKUP ,AR_LOOKUPS LOOKUP1 ,AR_PAYMENT_SCHEDULES PS ,OKL_STRM_TYPE_v SM WHERE HDR.ID = IWO.CONS_INVOICE_ID AND STREAM.LLN_ID =IWO.CONS_INVOICE_LINE_ID AND OKC.ID = IWO.CONTRACT_ID AND ico.object_id =okc.id AND del.PAYMENT_SCHEDULE_ID =IWO.TRANSACTION_ID AND PS.PAYMENT_SCHEDULE_ID =IWO.TRANSACTION_ID AND LOOKUP.LOOKUP_TYPE ='APPROVAL_TYPE' AND IWO.WRITEOFF_STATUS =LOOKUP.LOOKUP_CODE AND LOOKUP1.LOOKUP_TYPE ='ADJUST_REASON' AND IWO.ADJUSTMENT_REASON_CODE =LOOKUP1.LOOKUP_CODE AND SM.ID = STREAM.STY_ID

View Text - HTML Formatted

SELECT DISTINCT OKC.CONTRACT_NUMBER
, IWO.CONTRACT_ID
, IWO.CONS_INVOICE_ID
, HDR.CONSOLIDATED_INVOICE_NUMBER
, IWO.CONS_INVOICE_LINE_ID
, PS.CUSTOMER_TRX_ID
, IWO.TRANSACTION_ID
, PS.INVOICE_CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_APPLIED
, PS.AMOUNT_DUE_REMAINING
, ICO.CAS_ID
, DEL.DELINQUENCY_ID
, IWO.RECEVIABLES_ADJUSTMENT_ID
, LOOKUP.MEANING
, IWO.WRITEOFF_OBJECT_ID
, IWO.WRITEOFF_ID
, ADJUSTMENT_AMOUNT
, LOOKUP1.MEANING
, IWO.REQUEST_ID
, IWO.WRITEOFF_TYPE
, IWO.WRITEOFF_TYPE_ID
, IWO.WRITEOFF_STATUS
, SM.NAME
FROM OKL_CNSLD_AR_HDRS_B HDR
, OKL_CNSLD_AR_STRMS_B STREAM
, OKC_K_HEADERS_B OKC
, IEX_DELINQUENCIES DEL
, IEX_CASE_OBJECTS ICO
, IEX_WRITEOFF_OBJECTS IWO
, AR_LOOKUPS LOOKUP
, AR_LOOKUPS LOOKUP1
, AR_PAYMENT_SCHEDULES PS
, OKL_STRM_TYPE_V SM
WHERE HDR.ID = IWO.CONS_INVOICE_ID
AND STREAM.LLN_ID =IWO.CONS_INVOICE_LINE_ID
AND OKC.ID = IWO.CONTRACT_ID
AND ICO.OBJECT_ID =OKC.ID
AND DEL.PAYMENT_SCHEDULE_ID =IWO.TRANSACTION_ID
AND PS.PAYMENT_SCHEDULE_ID =IWO.TRANSACTION_ID
AND LOOKUP.LOOKUP_TYPE ='APPROVAL_TYPE'
AND IWO.WRITEOFF_STATUS =LOOKUP.LOOKUP_CODE
AND LOOKUP1.LOOKUP_TYPE ='ADJUST_REASON'
AND IWO.ADJUSTMENT_REASON_CODE =LOOKUP1.LOOKUP_CODE
AND SM.ID = STREAM.STY_ID