VIEW: APPS.OKX_TXN_BILLING_TYPES_V

Source

View Text - Preformatted

SELECT TBT.TXN_BILLING_TYPE_ID ID1, '#' ID2, TBT.BILLING_TYPE BILLING_TYPE, TBT.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, DECODE(SIGN(trunc(sysdate)-NVL(tbt.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(tbt.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, TL.NAME NAME, TL.DESCRIPTION DESCRIPTION, TBT.START_DATE_ACTIVE START_DATE_ACTIVE, TBT.END_DATE_ACTIVE END_DATE_ACTIVE, NULL INVENTORY_ITEM_ID, NULL ORGANIZATION_ID, NULL PRIMARY_UOM_CODE FROM CS_TXN_BILLING_TYPES TBT,CS_TRANSACTION_TYPES_B B,CS_TRANSACTION_TYPES_TL TL WHERE B.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID and TL.LANGUAGE = userenv('LANG') and B.TRANSACTION_TYPE_ID = TBT.TRANSACTION_TYPE_ID

View Text - HTML Formatted

SELECT TBT.TXN_BILLING_TYPE_ID ID1
, '#' ID2
, TBT.BILLING_TYPE BILLING_TYPE
, TBT.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TBT.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(TBT.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, TL.NAME NAME
, TL.DESCRIPTION DESCRIPTION
, TBT.START_DATE_ACTIVE START_DATE_ACTIVE
, TBT.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
, NULL PRIMARY_UOM_CODE
FROM CS_TXN_BILLING_TYPES TBT
, CS_TRANSACTION_TYPES_B B
, CS_TRANSACTION_TYPES_TL TL
WHERE B.TRANSACTION_TYPE_ID = TL.TRANSACTION_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND B.TRANSACTION_TYPE_ID = TBT.TRANSACTION_TYPE_ID