View: OKI_BILL_HIST_V

Product:	OKI - Contracts Intelligence
Description:	The billing history for service contracts.
Implementation/DBA Data:	APPS.OKI_BILL_HIST_V

View Text

SELECT SIL.CHR_ID CONTRACT_ID
, SIL.CLE_ID CONTRACT_LINE_ID
, SIL.CONTRACT_NUMBER CONTRACT_NUMBER
, SIL.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, SIL.LINE_NUMBER LINE_NUMBER
, BTN.TRX_DATE INVOICE_DATE
, BTN.TRX_NUMBER INVOICE_NUMBER
, BTN.TRX_AMOUNT INVOICE_AMOUNT
, BTN.CURRENCY_CODE CURRENCY_CODE
, BTN.TRX_CLASS INVOICE_CLASS
, BCL.AMOUNT LINE_AMOUNT
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, BCL.BILL_ACTION
FROM OKI_SOLD_ITM_LINES SIL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TRANSACTIONS BTN
WHERE BTN.ID = BCL.BTN_ID
AND BCL.CLE_ID = SIL.CLE_ID

Columns