[Home] [Help]
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
Name |
TRX_TYPE |
TRX_NUMBER |
TRX_DATE |
DATE_BILLED_FROM |
DATE_BILLED_TO |
AMOUNT |
TAX_AMOUNT |
CURRENCY_CODE |
QUANTITY_BILLED |
FIXED_QTYN |
ACTUAL_QTY |
DEFAULT_QTY |
MINIMUM_QTY |
BCL_ID |
TOP_LINE_ID |
BSL_ID |
SUB_LINE_ID |