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]

TABLE: IGS.IGP_AS_RESP_MAPPINGS

Object Details

Object Name:	IGP_AS_RESP_MAPPINGS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGP_AS_RESP_MAPPINGS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGP_AS_RESP_MAPPINGS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MAPPING_ID
IGP_AS_RESP_MAPPINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESPONSIBILITY_ID ACC_CLASSIFICATION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
MAPPING_ID	NUMBER		Yes	Stores the sequence generated Mapping ID.
TAG	VARCHAR2	(30)	Yes	Stores the value of the Tab from which the record was created. Because we are not having the application id to segregate between the portfolio responsibility and OSS responsibility , so this value will help us to show the record in the same tab from which it was created. Possible two values are �IGP� and �IGS�. These values will be hard-coded.
RESPONSIBILITY_ID	NUMBER	(15)	Yes	Stores the responsibility id of the Portfolio Responsibility to which the mapping is being done
ACC_CLASSIFICATION_CODE	VARCHAR2	(30)	Yes	Stores the account classification against which the responsibility is being mapped
ENABLE_FLAG	VARCHAR2	(1)	Yes	Mapping is enabled or not
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER		Yes	To store the object version number

Query Text

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


SELECT MAPPING_ID
,      TAG
,      RESPONSIBILITY_ID
,      ACC_CLASSIFICATION_CODE
,      ENABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM IGS.IGP_AS_RESP_MAPPINGS;

Dependencies

[top of page]

IGS.IGP_AS_RESP_MAPPINGS does not reference any database object

IGS.IGP_AS_RESP_MAPPINGS is referenced by following:

APPS: IGP_AS_RESP_MAPPINGS