VIEW: APPS.IGI_MPP_EXPENSE_RULES

Source

View Text - Preformatted

SELECT set_of_books_id , expense_ccid , last_updated_by , last_update_date , created_by , creation_date , default_accounting_rule_id , enabled_flag , last_update_login , org_id FROM IGI_MPP_EXPENSE_RULES_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)

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID
, EXPENSE_CCID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, DEFAULT_ACCOUNTING_RULE_ID
, ENABLED_FLAG
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGI_MPP_EXPENSE_RULES_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)