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.IGS_AD_SOURCE_CAT_ALL

Object Details

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

IGS_AD_SOURCE_CAT_ALL holds details for user source categories.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_SOURCE_CAT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TYPE_ID
IGS_AD_SOURCE_CAT_ALL_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SRC_CAT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Operating unit identifier
SRC_CAT_ID	NUMBER	(15)	Yes	Source category identifier is the unique identifier
SOURCE_TYPE_ID	NUMBER	(15)	Yes	Source type identifier is the parent of the source category type contained in IGS_PE_SRC_TYPES.
CATEGORY_NAME	VARCHAR2	(30)	Yes	Name of the source category
MANDATORY_IND	VARCHAR2	(1)		Mandatory indicator to tell whether the source category is mandatory within a source type
INCLUDE_IND	VARCHAR2	(1)	Yes	Include indicator tells whether the source category is to be included if it is not mandatory
SS_MANDATORY_IND	VARCHAR2	(1)		Mandatory indicator for self service categories - Obsolete
DISCREPANCY_RULE_CD	VARCHAR2	(30)	Yes	Discrepancy rule code
SS_IND	VARCHAR2	(1)		Self Service Indicator - Obsolete
DISPLAY_SEQUENCE	NUMBER	(5)		Display Sequence - Obsolete
DETAIL_LEVEL_IND	VARCHAR2	(1)		Indicator for setting discrepancy rules at the Detail Level
AD_TAB_NAME	VARCHAR2	(30)		Corresponding Admission table name
INT_TAB_NAME	VARCHAR2	(30)		Corresponding Interface table name
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

Query Text

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


SELECT ORG_ID
,      SRC_CAT_ID
,      SOURCE_TYPE_ID
,      CATEGORY_NAME
,      MANDATORY_IND
,      INCLUDE_IND
,      SS_MANDATORY_IND
,      DISCREPANCY_RULE_CD
,      SS_IND
,      DISPLAY_SEQUENCE
,      DETAIL_LEVEL_IND
,      AD_TAB_NAME
,      INT_TAB_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_SOURCE_CAT_ALL;

Dependencies

[top of page]

IGS.IGS_AD_SOURCE_CAT_ALL does not reference any database object

IGS.IGS_AD_SOURCE_CAT_ALL is referenced by following:

APPS: IGS_AD_SOURCE_CAT_ALL