VIEW: APPS.OKS_BILLING_HIST_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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