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_PS_SCH_LOC_INT

Object Details

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

Contains the location including building and room information that is setup at the unit offering pattern level and can be cross referenced back to IGS_PS_SCH_PAT_INT. This information is used to create unit section and unit section occurrence level data.The corresponding production table is IGS_PS_UNIT_LOCATION.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export Scheduling Unit Offering Pattern Location Detail
Category: BUSINESS_ENTITY IGS_UNIT

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_SCH_LOC_INT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	INT_LOC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INT_LOC_ID	NUMBER		Yes	Unique Identifier for each Unit Offering Pattern location in the Scheduler Interface.
INT_PAT_ID	NUMBER		Yes	Identifier for a Unit Offering Pattern in scheduling interface.
LOCATION_CODE	VARCHAR2	(10)	Yes	Location Code corresponding to the Unit Version of the Unit Offering Pattern.
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	Location description corresponding to the Unit Version of the Unit Offering Pattern.
BUILDING_CODE	VARCHAR2	(10)		Building Code corresponding to the Unit Version of the Unit Offering Pattern.
BUILDING_DESCRIPTION	VARCHAR2	(80)		Building description corresponding to the Unit Version of the Unit Offering Pattern.
ROOM_CODE	VARCHAR2	(10)		Room Code corresponding to the Unit Version of the Unit Offering Pattern.
ROOM_DESCRIPTION	VARCHAR2	(80)		Room description corresponding to the Unit Version of the Unit Offering Pattern.
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 INT_LOC_ID
,      INT_PAT_ID
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      BUILDING_CODE
,      BUILDING_DESCRIPTION
,      ROOM_CODE
,      ROOM_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_SCH_LOC_INT;

Dependencies

[top of page]

IGS.IGS_PS_SCH_LOC_INT does not reference any database object

IGS.IGS_PS_SCH_LOC_INT is referenced by following:

APPS: IGS_PS_SCH_LOC_INT