View: IGS_CO_MAPPING_V

Product:	IGS - Student System
Description:	Mapping and Attributes
Implementation/DBA Data:	APPS.IGS_CO_MAPPING_V

View Text

SELECT CMAP.ROWID ROW_ID
, CMAP.MAP_ID
, CMAP.MAP_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_MAP_TYPE'
, CMAP.MAP_CODE) MAP_TYPE
, CMAP.DOC_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_DOC_TYPE'
, CMAP.DOC_CODE) DOCUMENT_TYPE
, CMAP.DOCUMENT_ID
, CITM.NAME NAME
, CITM.DESCRIPTION DESCRIPTION
, CMAP.ENABLE_FLAG
, CMAP.SYS_LTR_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_SYS_LTR_CODE'
, CMAP.SYS_LTR_CODE) APPLICATION_NAME
, CMAP.MAP_DESCRIPTION
, CMAP.ELAPSED_DAYS
, CMAP.REPEAT_TIMES
, CMAP.ATTR_DESCRIPTION
, CMAP.CREATED_BY
, CMAP.CREATION_DATE
, CMAP.LAST_UPDATED_BY
, CMAP.LAST_UPDATE_DATE
, CMAP.LAST_UPDATE_LOGIN
, CITM.VERSION VERSION_ID
, NULL EMAI
, NULL FAX
, NULL PRINT
, CITM.CITEM_VER_ID
FROM IGS_CO_MAPPING CMAP
, IBC_CITEMS_V CITM
, IBC_CONTENT_ITEMS CONITEM
WHERE CMAP.DOCUMENT_ID=CITM.CITEM_ID
AND CITM.CTYPE_CODE='IBC_QUERY'
AND MAP_CODE='LIST'
AND CITM.LANGUAGE = USERENV('LANG')
AND CITM.CITEM_ID = CONITEM.CONTENT_ITEM_ID
AND CITM.CITEM_VER_ID = CONITEM.LIVE_CITEM_VERSION_ID UNION ALL SELECT CMAP.ROWID ROW_ID
, CMAP.MAP_ID
, CMAP.MAP_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_MAP_TYPE'
, CMAP.MAP_CODE) MAP_TYPE
, CMAP.DOC_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_DOC_TYPE'
, CMAP.DOC_CODE) DOCUMENT_TYPE
, CMAP.DOCUMENT_ID
, CITM.NAME NAME
, CITM.DESCRIPTION DESCRIPTION
, CMAP.ENABLE_FLAG
, CMAP.SYS_LTR_CODE
, IGS_GE_GEN_004.GENP_GET_LOOKUP('IGS_CO_SYS_LTR_CODE'
, CMAP.SYS_LTR_CODE) APPLICATION_NAME
, CMAP.MAP_DESCRIPTION
, CMAP.ELAPSED_DAYS
, CMAP.REPEAT_TIMES
, CMAP.ATTR_DESCRIPTION
, CMAP.CREATED_BY
, CMAP.CREATION_DATE
, CMAP.LAST_UPDATED_BY
, CMAP.LAST_UPDATE_DATE
, CMAP.LAST_UPDATE_LOGIN
, CITM.VERSION VERSION_ID
, NVL((SELECT 'Y'
FROM IBC_CTYPE_GROUP_NODES
WHERE DIRECTORY_NODE_ID='33'
AND CONTENT_TYPE_CODE=CITM.CTYPE_CODE)
, 'N') EMAIL
, NVL((SELECT 'Y'
FROM IBC_CTYPE_GROUP_NODES
WHERE DIRECTORY_NODE_ID='32'
AND CONTENT_TYPE_CODE=CITM.CTYPE_CODE)
, 'N') FAX
, NVL((SELECT 'Y'
FROM IBC_CTYPE_GROUP_NODES
WHERE DIRECTORY_NODE_ID='34'
AND CONTENT_TYPE_CODE=CITM.CTYPE_CODE)
, 'N') PRINT
, CITM.CITEM_VER_ID
FROM IGS_CO_MAPPING CMAP
, IBC_CITEMS_V CITM
, IBC_CONTENT_ITEMS CONITEM
WHERE CMAP.DOCUMENT_ID=CITM.CITEM_ID
AND CITM.CITEM_ID = CONITEM.CONTENT_ITEM_ID
AND CITM.CITEM_VER_ID = CONITEM.LIVE_CITEM_VERSION_ID
AND CMAP.MAP_CODE='DOCUMENT'
AND CITM.LANGUAGE = USERENV('LANG')

Columns