[Home] [Help]
View: IGI_CEC_ENCUMBRANCE_TYPES
Product: | IGI - Public Sector Financials International |
Description: | Based on IGI_CEC_ENCUMBRANCE_TYPES_ALL |
Implementation/DBA Data: |
APPS.IGI_CEC_ENCUMBRANCE_TYPES
|
View Text
SELECT SET_OF_BOOKS_ID
, IGI_CEC_CE_TYPE_ID
, IGI_CEC_CE_FLAG
FROM IGI_CEC_ENCUMBRANCE_TYPES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
Columns
Name |
SET_OF_BOOKS_ID |
IGI_CEC_CE_TYPE_ID |
IGI_CEC_CE_FLAG |