VIEW: APPS.IGI_EXP_NUM_SCHEMES_V

Source

View Text - Preformatted

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_ALL 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_ALL IETTH WHERE IENS.DU_TU_TYPE_ID = IETTH.TU_TYPE_HEADER_ID AND IENS.NUMBERING_TYPE = 'TU'

View Text - HTML Formatted

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_ALL 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_ALL IETTH
WHERE IENS.DU_TU_TYPE_ID = IETTH.TU_TYPE_HEADER_ID
AND IENS.NUMBERING_TYPE = 'TU'