VIEW: APPS.CN_LEDGER_BAL_TYPES_VL

Source

View Text - Preformatted

SELECT T.BALANCE_NAME , B.STATISTICAL_TYPE , B.PAYMENT_TYPE , B.BALANCE_ID , B.COLUMN_NAME , B.BALANCE_TYPE , B.SCREEN_SEQUENCE , B.ORG_ID , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN FROM CN_LEDGER_BAL_TYPES_ALL_B B, CN_LEDGER_BAL_TYPES_ALL_TL T WHERE B.BALANCE_ID = T.BALANCE_ID AND NVL(B.ORG_ID, -99) = NVL(T.ORG_ID, -99) AND NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT T.BALANCE_NAME
, B.STATISTICAL_TYPE
, B.PAYMENT_TYPE
, B.BALANCE_ID
, B.COLUMN_NAME
, B.BALANCE_TYPE
, B.SCREEN_SEQUENCE
, B.ORG_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
FROM CN_LEDGER_BAL_TYPES_ALL_B B
, CN_LEDGER_BAL_TYPES_ALL_TL T
WHERE B.BALANCE_ID = T.BALANCE_ID
AND NVL(B.ORG_ID
, -99) = NVL(T.ORG_ID
, -99)
AND NVL(B.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND T.LANGUAGE = USERENV('LANG')