View: OKS_BILLING_HIST_LINES_V

Product:	OKS - Service Contracts
Description:	View for Service Contracts Billing History Lines
Implementation/DBA Data:	APPS.OKS_BILLING_HIST_LINES_V

View Text

SELECT BSL.ROWID ROW_ID
, BSL.ID ID
, BSL.BCL_ID BCL_ID
, LST.NAME BILL_LEVEL
, KLE.NAME NAME
, BSL.DATE_BILLED_FROM BILL_FROM
, BSL.DATE_BILLED_TO BILL_TO
, BSL.AMOUNT AMOUNT
, BSD.RESULT RESULT
FROM OKC_K_LINES_V KLE
, OKC_LINE_STYLES_V LST
, OKS_BILL_SUB_LINES BSL
, OKS_BILL_SUB_LINE_DTLS BSD
WHERE KLE.LSE_ID = LST.ID
AND KLE.ID = BSL.CLE_ID
AND BSL.ID = BSD.BSL_ID

Columns