VIEW: APPS.OKS_BILLING_DTLS_V

Source

View Text - Preformatted

SELECT btra.trx_number INVOICE_NUMBER ,btra.trx_date INVOICE_DATE ,btxn.trx_line_amount INVOICE_LINE_AMOUNT ,btxn.trx_line_tax_amount INVOICE_LINE_TAX_AMOUNT ,btxn.bill_instance_number BILL_INSTANCE_NUMBER ,bcont.date_billed_from BILL_FROM_DATE ,bcont.date_billed_to BILL_FROM_TO ,bsub.cle_id CLE_ID ,bsub.bcl_id BCL_ID from oks_bill_transactions btra ,oks_bill_txn_lines btxn ,oks_bill_cont_lines bcont ,oks_bill_sub_lines bsub WHERE bsub.bcl_id = bcont.id and bcont.btn_id = btra.id and btra.id = btxn.btn_id and btxn.bsl_id = bsub.id

View Text - HTML Formatted

SELECT BTRA.TRX_NUMBER INVOICE_NUMBER
, BTRA.TRX_DATE INVOICE_DATE
, BTXN.TRX_LINE_AMOUNT INVOICE_LINE_AMOUNT
, BTXN.TRX_LINE_TAX_AMOUNT INVOICE_LINE_TAX_AMOUNT
, BTXN.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
, BCONT.DATE_BILLED_FROM BILL_FROM_DATE
, BCONT.DATE_BILLED_TO BILL_FROM_TO
, BSUB.CLE_ID CLE_ID
, BSUB.BCL_ID BCL_ID
FROM OKS_BILL_TRANSACTIONS BTRA
, OKS_BILL_TXN_LINES BTXN
, OKS_BILL_CONT_LINES BCONT
, OKS_BILL_SUB_LINES BSUB
WHERE BSUB.BCL_ID = BCONT.ID
AND BCONT.BTN_ID = BTRA.ID
AND BTRA.ID = BTXN.BTN_ID
AND BTXN.BSL_ID = BSUB.ID