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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_CO_MAPPING_V

Object Details

Object Name:	IGS_CO_MAPPING_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_CO_MAPPING_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mapping and Attributes

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row Identifier
MAP_ID	NUMBER	(15)	Mapping Identifier
MAP_CODE	VARCHAR2	(30)	Mapping Type Code
MAP_TYPE	VARCHAR2	(4000)	Mapping Type Description
DOC_CODE	VARCHAR2	(30)	Document Type Code
DOCUMENT_TYPE	VARCHAR2	(4000)	Document Type Description
DOCUMENT_ID	NUMBER	(15)	Document or List Identifier
NAME	VARCHAR2	(240)	Document or List Name
DESCRIPTION	VARCHAR2	(2000)	Document or List Description
ENABLE_FLAG	VARCHAR2	(1)	Enabled Flag
SYS_LTR_CODE	VARCHAR2	(10)	System Letter Code
APPLICATION_NAME	VARCHAR2	(4000)	Application Name
MAP_DESCRIPTION	VARCHAR2	(250)	Mapping Description
ELAPSED_DAYS	NUMBER	(3)	Number of Days within which a Document can be Sent
REPEAT_TIMES	NUMBER	(3)	Number of times a Document can be Sent
ATTR_DESCRIPTION	VARCHAR2	(250)	Attribute Description
CREATED_BY	NUMBER	(15)	Standard WHO Column
CREATION_DATE	DATE		Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO Column
LAST_UPDATE_DATE	DATE		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard WHO Column
VERSION_ID	NUMBER	(15)	Version Information of the content item
EMAIL	VARCHAR2	(1)	Indicate whether Email Channel is available for the content
FAX	VARCHAR2	(1)	Indicate whether Fax Channel is available for the content
PRINT	VARCHAR2	(1)	Indicate whether Print Channel is available for the content
CITEM_VER_ID	NUMBER		Live version item information

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      MAP_ID
,      MAP_CODE
,      MAP_TYPE
,      DOC_CODE
,      DOCUMENT_TYPE
,      DOCUMENT_ID
,      NAME
,      DESCRIPTION
,      ENABLE_FLAG
,      SYS_LTR_CODE
,      APPLICATION_NAME
,      MAP_DESCRIPTION
,      ELAPSED_DAYS
,      REPEAT_TIMES
,      ATTR_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VERSION_ID
,      EMAIL
,      FAX
,      PRINT
,      CITEM_VER_ID
FROM APPS.IGS_CO_MAPPING_V;

Dependencies

[top of page]

APPS.IGS_CO_MAPPING_V references the following:

APPS: IBC_CITEMS_V; IBC_CONTENT_ITEMS; IBC_CTYPE_GROUP_NODES; IGS_CO_MAPPING; IGS_GE_GEN_004 - show dependent code

APPS.IGS_CO_MAPPING_V is referenced by following:

APPS: IGF_AW_GEN_004 - show dependent code; IGS_CO_PROCESS - show dependent code