[Home] [Help]
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
Name |
ROW_ID |
ID |
BCL_ID |
BILL_LEVEL |
NAME |
BILL_FROM |
BILL_TO |
AMOUNT |
RESULT |