View: OKS_BILLING_HISTORY_V

Product:	OKS - Service Contracts
Description:	View used in Spredtable to display Billing History
Implementation/DBA Data:	APPS.OKS_BILLING_HISTORY_V

View Text

SELECT FND.MEANING TRX_TYPE
, BTL.TRX_NUMBER TRX_NUMBER
, BTL.TRX_DATE TRX_DATE
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, TO_NUMBER(BTL.TRX_LINE_AMOUNT ) AMOUNT
, BTL.TRX_LINE_TAX_AMOUNT TAX_AMOUNT
, BCL.CURRENCY_CODE CURRENCY_CODE
, NULL QUANTITY_BILLED
, NULL FIXED_QTY
, NULL ACTUAL_QTY
, NULL DEFAULT_QTY
, NULL MINIMUM_QTY
, BCL.ID BCL_ID
, BCL.CLE_ID TOP_LINE_ID
, NULL BSL_ID
, NULL SUB_LINE_ID
FROM FND_LOOKUPS FND
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TXN_LINES BTL
WHERE BCL.BTN_ID = BTL.BTN_ID
AND BTL.BSL_ID IS NULL
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS' UNION ALL SELECT FND.MEANING TRX_TYPE
, BTL.TRX_NUMBER TRX_NUMBER
, BTL.TRX_DATE TRX_DATE
, BCL.DATE_BILLED_FROM
, BCL.DATE_BILLED_TO
, TO_NUMBER(BTL.TRX_LINE_AMOUNT) AMOUNT
, BTL.TRX_LINE_TAX_AMOUNT TAX_AMOUNT
, BCL.CURRENCY_CODE
, BSD.RESULT QUANTITY_BILLED
, BSD.FIXED FIXED_QTY
, BSD.ACTUAL ACTUAL_QTY
, BSD.DEFAULT_DEFAULT DEFAULT_QTY
, BSD.ADJUSTMENT_MINIMUM MINIMUM_QTY
, BCL.ID BCL_ID
, BCL.CLE_ID TOP_LINE_ID
, BSL.ID BSL_ID
, BSL.CLE_ID SUB_LINE_ID
FROM FND_LOOKUPS FND
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TXN_LINES BTL
, OKS_BILL_SUB_LINES BSL
, OKS_BILL_SUB_LINE_DTLS BSD
WHERE BCL.BTN_ID = BTL.BTN_ID
AND BSD.BSL_ID = BTL.BSL_ID
AND BSL.BCL_ID = BCL.ID
AND BSD.BSL_ID = BSL.ID
AND BTL.BSL_ID IS NOT NULL
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS' UNION ALL SELECT FND.MEANING TRX_TYPE
, NULL TRX_NUMBER
, NULL TRX_DATE
, BSL.DATE_BILLED_FROM
, BSL.DATE_BILLED_TO
, BSL.AMOUNT AMOUNT
, NULL TAX_AMOUNT
, BCL.CURRENCY_CODE
, NULL QUANTITY_BILLED
, NULL FIXED_QTY
, NULL ACTUAL_QTY
, NULL DEFAULT_QTY
, NULL MINIMUM_QTY
, BCL.ID BCL_ID
, BCL.CLE_ID TOP_LINE_ID
, BSL.ID BSL_ID
, BSL.CLE_ID SUB_LINE_ID
FROM FND_LOOKUPS FND
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_SUB_LINES BSL
WHERE BCL.BTN_ID = -44
AND BCL.ID = BSL.BCL_ID
AND BCL.BILL_ACTION = FND.LOOKUP_CODE
AND FND.LOOKUP_CODE = 'RI'
AND FND.LOOKUP_TYPE = 'OKS_BILL_ACTIONS'

Columns