View: OKS_INV_RVW_V

Product:	OKS - Service Contracts
Description:	View for Invoice reporting
Implementation/DBA Data:	APPS.OKS_INV_RVW_V

View Text

SELECT BCL.ID BCL_ID
, NVL(BTL.TRX_NUMBER
, BTR.TRX_NUMBER) INVOICE_NUMBER
, NVL(BTL.TRX_CLASS
, BTR.TRX_CLASS ) INVOICE_CLASS
, FND.MEANING TRANSACTION_TYPE
, BCL.CLE_ID BCL_CLE_ID
, TO_NUMBER( NULL ) BSL_CLE_ID
, BCL.BTN_ID BTN_ID
, BTL.ID BTL_ID
, BTL.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
, NVL(BTL.TRX_DATE
, BTR.TRX_DATE ) INVOICE_DATE
, BCL.DATE_BILLED_FROM BCL_BILL_FROM_DATE
, BCL.DATE_BILLED_TO BCL_BILL_TO_DATE
, TO_DATE(NULL) BSL_BILL_FROM_DATE
, TO_DATE(NULL) BSL_BILL_TO_DATE
, BCL.CURRENCY_CODE CURRENCY_CODE
FROM OKS_BILL_TRANSACTIONS BTR
, OKS_BILL_TXN_LINES BTL
, OKS_BILL_CONT_LINES BCL
, FND_LOOKUPS FND
WHERE BTR.ID = BTL.BTN_ID
AND BTL.BCL_ID = BCL.ID
AND BCL.BTN_ID = BTR.ID
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS'
AND BTL.BSL_ID IS NULL UNION ALL SELECT BCL.ID BCL_ID
, NVL(BTL.TRX_NUMBER
, BTR.TRX_NUMBER ) INVOICE_NUMBER
, NVL(BTL.TRX_CLASS
, BTR.TRX_CLASS ) INVOICE_CLASS
, FND.MEANING TRANSACTION_TYPE
, BCL.CLE_ID BCL_CLE_ID
, BSL.CLE_ID BSL_CLE_ID
, BCL.BTN_ID BTN_ID
, BTL.ID BTL_ID
, BTL.BILL_INSTANCE_NUMBER BILL_INSTANCE_NUMBER
, NVL(BTL.TRX_DATE
, BTR.TRX_DATE) INVOICE_DATE
, BCL.DATE_BILLED_FROM BCL_BILL_FROM_DATE
, BCL.DATE_BILLED_TO BCL_BILL_TO_DATE
, BSL.DATE_BILLED_FROM BSL_BILL_FROM_DATE
, BSL.DATE_BILLED_TO BSL_BILL_TO_DATE
, BCL.CURRENCY_CODE CURRENCY_CODE
FROM OKS_BILL_TRANSACTIONS BTR
, OKS_BILL_TXN_LINES BTL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_SUB_LINES BSL
, FND_LOOKUPS FND
WHERE BCL.ID = BSL.BCL_ID
AND BTL.BSL_ID = BSL.ID
AND BTL.BTN_ID = BTR.ID
AND BCL.BTN_ID = BTR.ID
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS'

Columns