[Home] [Help]
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
Name |
INVOICE_NUMBER |
INVOICE_DATE |
INVOICE_LINE_AMOUNT |
INVOICE_LINE_TAX_AMOUNT |
BILL_INSTANCE_NUMBER |
BILL_FROM_DATE |
BILL_TO_DATE |
CLE_ID |
BCL_ID |