Product: | IGI - Public Sector Financials International |
---|---|
Description: | Multi org view which displays all the code combinations and numbering information for Exchange Protocol numbering. |
Implementation/DBA Data: | APPS.IGI_EXP_NUMBERING |
SELECT "NUMBER_ID"
, "EP_NUMBERING_TYPE"
, "EP_DOCUMENT_CLASS"
, "EP_DOCUMENT_TYPE"
, "EP_NUMBERING_CODE"
, "DOCUMENT_CLASS_CODE"
, "DOCUMENT_TYPE_CODE"
, "APPLICATION"
, "FISCAL_YEAR"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "TRX_TYPE_CODE"
, "EP_TRX_TYPE"
, "ORG_ID"
, "PREFIX"
, "SUFFIX"
, "NEXT_SEQ_VAL"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
FROM IGI_EXP_NUMBERING_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)