View: OKS_BILLING_DTLS_V

Product:	OKS - Service Contracts
Description:	Service contracts billing details view.
Implementation/DBA Data:	APPS.OKS_BILLING_DTLS_V

View Text

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

Columns