VIEW: APPS.IEX_WRITTENOFF_INVOICES_V2

Source

View Text - Preformatted

SELECT iwo.writeoff_id writeoff_id, iwo.customer_trx_id customer_trx_id, iwo.customer_trx_line_id customer_trx_line_id, okv.invoice_number invoice_number, okv.invoice_amount invoice_amount, okv.line_identifier line_number, okv.currency_code currency_code, iwo.receviables_adjustment_id receviables_adjustment_id, alk.meaning approval_type, iwo.writeoff_object_id writeoff_object_id, okv.transaction_amount line_amount, okv.amount_applied amount_applied, okv.amount_remaining amount_remaining, iwo.adjustment_amount adjustment_amount, alk1.meaning adjust_reason, iwo.request_id request_id, iwo.writeoff_type writeoff_type, iwo.writeoff_type_id writeoff_type_id, iwo.writeoff_status writeoff_status FROM IEX_CS_BILLINGTRX_UV1 okv, IEX_WRITEOFF_OBJECTS iwo, AR_LOOKUPS alk, AR_LOOKUPS alk1 WHERE okv.customer_trx_id = iwo.customer_trx_id and okv.invoice_line_id = iwo.customer_trx_line_id and okv.khr_id = iwo.contract_id and alk.lookup_type = 'APPROVAL_TYPE' and alk.lookup_code = iwo.writeoff_status and alk1.lookup_type = 'ADJUST_REASON' and alk1.lookup_code = iwo.adjustment_reason_code

View Text - HTML Formatted

SELECT IWO.WRITEOFF_ID WRITEOFF_ID
, IWO.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, IWO.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, OKV.INVOICE_NUMBER INVOICE_NUMBER
, OKV.INVOICE_AMOUNT INVOICE_AMOUNT
, OKV.LINE_IDENTIFIER LINE_NUMBER
, OKV.CURRENCY_CODE CURRENCY_CODE
, IWO.RECEVIABLES_ADJUSTMENT_ID RECEVIABLES_ADJUSTMENT_ID
, ALK.MEANING APPROVAL_TYPE
, IWO.WRITEOFF_OBJECT_ID WRITEOFF_OBJECT_ID
, OKV.TRANSACTION_AMOUNT LINE_AMOUNT
, OKV.AMOUNT_APPLIED AMOUNT_APPLIED
, OKV.AMOUNT_REMAINING AMOUNT_REMAINING
, IWO.ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, ALK1.MEANING ADJUST_REASON
, IWO.REQUEST_ID REQUEST_ID
, IWO.WRITEOFF_TYPE WRITEOFF_TYPE
, IWO.WRITEOFF_TYPE_ID WRITEOFF_TYPE_ID
, IWO.WRITEOFF_STATUS WRITEOFF_STATUS
FROM IEX_CS_BILLINGTRX_UV1 OKV
, IEX_WRITEOFF_OBJECTS IWO
, AR_LOOKUPS ALK
, AR_LOOKUPS ALK1
WHERE OKV.CUSTOMER_TRX_ID = IWO.CUSTOMER_TRX_ID
AND OKV.INVOICE_LINE_ID = IWO.CUSTOMER_TRX_LINE_ID
AND OKV.KHR_ID = IWO.CONTRACT_ID
AND ALK.LOOKUP_TYPE = 'APPROVAL_TYPE'
AND ALK.LOOKUP_CODE = IWO.WRITEOFF_STATUS
AND ALK1.LOOKUP_TYPE = 'ADJUST_REASON'
AND ALK1.LOOKUP_CODE = IWO.ADJUSTMENT_REASON_CODE