eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGI_EXP_NUM_SCHEMES_V

Product:	IGI - Public Sector Financials International
Description:	Displays the single Organization view of Numering Schemes for Dialog Units and Transmission Units along with the Dialog Unit Type and Transmission Unit Type Names.
Implementation/DBA Data:	APPS.IGI_EXP_NUM_SCHEMES_V

View Text

SELECT IEDTH.DU_TYPE_NAME DU_TU_TYPE_NAME
, IENS.ROWID ROW_ID
, IENS.NUM_SCHEME_ID
, IENS.NUMBERING_TYPE
, IENS.NUMBERING_CLASS
, IENS.DU_TU_TYPE_ID
, IENS.PREFIX
, IENS.SUFFIX
, IENS.FISCAL_YEAR
, IENS.NEXT_SEQ_VAL
, IENS.ORG_ID
, IENS.CREATION_DATE
, IENS.CREATED_BY
, IENS.LAST_UPDATE_LOGIN
, IENS.LAST_UPDATE_DATE
, IENS.LAST_UPDATED_BY
FROM IGI_EXP_NUM_SCHEMES IENS
, IGI_EXP_DU_TYPE_HEADERS IEDTH
WHERE IENS.DU_TU_TYPE_ID = IEDTH.DU_TYPE_HEADER_ID
AND IENS.NUMBERING_TYPE = 'DU' UNION ALL SELECT IETTH.TU_TYPE_NAME DU_TU_TYPE_NAME
, IENS.ROWID ROW_ID
, IENS.NUM_SCHEME_ID
, IENS.NUMBERING_TYPE
, IENS.NUMBERING_CLASS
, IENS.DU_TU_TYPE_ID
, IENS.PREFIX
, IENS.SUFFIX
, IENS.FISCAL_YEAR
, IENS.NEXT_SEQ_VAL
, IENS.ORG_ID
, IENS.CREATION_DATE
, IENS.CREATED_BY
, IENS.LAST_UPDATE_LOGIN
, IENS.LAST_UPDATE_DATE
, IENS.LAST_UPDATED_BY
FROM IGI_EXP_NUM_SCHEMES IENS
, IGI_EXP_TU_TYPE_HEADERS IETTH
WHERE IENS.DU_TU_TYPE_ID = IETTH.TU_TYPE_HEADER_ID
AND IENS.NUMBERING_TYPE = 'TU'

Columns

Name
DU_TU_TYPE_NAME
ROW_ID
NUM_SCHEME_ID
NUMBERING_TYPE
NUMBERING_CLASS
DU_TU_TYPE_ID
PREFIX
SUFFIX
FISCAL_YEAR
NEXT_SEQ_VAL
ORG_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
LAST_UPDATED_BY