VIEW: APPS.OKS_INV_RVW_V

Source

View Text - Preformatted

SELECT bcl.id bcl_id ,nvl(btl.trx_number , btr.TRX_NUMBER) invoice_number ,nvl(btl.trx_class , btr.trx_class ) invoice_class , fnd.meaning transaction_type , bcl.cle_id bcl_cle_id ,to_number( null ) bsl_cle_id , bcl.btn_id btn_id , btl.id btl_id , btl.BILL_INSTANCE_NUMBER bill_instance_number , nvl(btl.trx_date , bTR.TRX_DATE ) INVOICE_date , bcl.DATE_BILLED_FROM BCL_bill_from_date , bcl.DATE_BILLED_TO BCL_bill_to_date , to_date(null) BSL_bill_from_date , to_date(null) BsL_bill_to_date , bcl.currency_code currency_code FROM oks_bill_transactions btr , oks_bill_txn_lines btl , oks_bill_cont_lines bcl , fnd_lookups fnd WHERE btr.id = btl.btn_id AND btl.BCL_ID = bcl.id AND bcl.BTN_ID = btr.ID AND bcl.bill_action = fnd.lookup_code AND fnd.lookup_type = 'OKS_BILL_ACTIONS' AND btl.bsl_id is null UNION ALL SELECT bcl.id bcl_id , nvl(btl.trx_number , btr.TRX_NUMBER ) invoice_number , nvl(btl.trx_class , btr.trx_class ) invoice_class , fnd.meaning transaction_type , bcl.cle_id bcl_cle_id , bsl.cle_id bsl_cle_id , bcl.btn_id btn_id , btl.id btl_id , btl.BILL_INSTANCE_NUMBER bill_instance_number ,nvl(btl.trx_date , bTR.TRX_date) INVOICE_date , bcl.DATE_BILLED_FROM BCL_bill_from_date , bcl.DATE_BILLED_TO BCL_bill_to_date , BSL.DATE_BILLED_FROM BSL_bill_from_date , BSL.DATE_BILLED_TO BsL_bill_to_date , bcl.currency_code currency_code FROM oks_bill_transactions btr , oks_bill_txn_lines btl , oks_bill_cont_lines bcl , oks_bill_sub_lines bsl , fnd_lookups fnd WHERE bcl.id = bsl.bcl_id AND btl.BSL_ID = bsl.id AND btl.BTN_ID = btr.ID AND bcl.BTN_ID = btr.ID AND bcl.bill_action = fnd.lookup_code AND fnd.lookup_type = 'OKS_BILL_ACTIONS'

View Text - HTML Formatted

SELECT BCL.ID BCL_ID
, NVL(BTL.TRX_NUMBER
, BTR.TRX_NUMBER) INVOICE_NUMBER
, NVL(BTL.TRX_CLASS
, BTR.TRX_CLASS ) INVOICE_CLASS
, FND.MEANING TRANSACTION_TYPE
, BCL.CLE_ID BCL_CLE_ID
, TO_NUMBER( NULL ) BSL_CLE_ID
, BCL.BTN_ID BTN_ID
, BTL.ID BTL_ID
, BTL.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
, NVL(BTL.TRX_DATE
, BTR.TRX_DATE ) INVOICE_DATE
, BCL.DATE_BILLED_FROM BCL_BILL_FROM_DATE
, BCL.DATE_BILLED_TO BCL_BILL_TO_DATE
, TO_DATE(NULL) BSL_BILL_FROM_DATE
, TO_DATE(NULL) BSL_BILL_TO_DATE
, BCL.CURRENCY_CODE CURRENCY_CODE
FROM OKS_BILL_TRANSACTIONS BTR
, OKS_BILL_TXN_LINES BTL
, OKS_BILL_CONT_LINES BCL
, FND_LOOKUPS FND
WHERE BTR.ID = BTL.BTN_ID
AND BTL.BCL_ID = BCL.ID
AND BCL.BTN_ID = BTR.ID
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS'
AND BTL.BSL_ID IS NULL UNION ALL SELECT BCL.ID BCL_ID
, NVL(BTL.TRX_NUMBER
, BTR.TRX_NUMBER ) INVOICE_NUMBER
, NVL(BTL.TRX_CLASS
, BTR.TRX_CLASS ) INVOICE_CLASS
, FND.MEANING TRANSACTION_TYPE
, BCL.CLE_ID BCL_CLE_ID
, BSL.CLE_ID BSL_CLE_ID
, BCL.BTN_ID BTN_ID
, BTL.ID BTL_ID
, BTL.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
, NVL(BTL.TRX_DATE
, BTR.TRX_DATE) INVOICE_DATE
, BCL.DATE_BILLED_FROM BCL_BILL_FROM_DATE
, BCL.DATE_BILLED_TO BCL_BILL_TO_DATE
, BSL.DATE_BILLED_FROM BSL_BILL_FROM_DATE
, BSL.DATE_BILLED_TO BSL_BILL_TO_DATE
, BCL.CURRENCY_CODE CURRENCY_CODE
FROM OKS_BILL_TRANSACTIONS BTR
, OKS_BILL_TXN_LINES BTL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_SUB_LINES BSL
, FND_LOOKUPS FND
WHERE BCL.ID = BSL.BCL_ID
AND BTL.BSL_ID = BSL.ID
AND BTL.BTN_ID = BTR.ID
AND BCL.BTN_ID = BTR.ID
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS'