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

TABLE: IGS.IGS_PS_SCH_FAC_INT

Object Details
Object Name: IGS_PS_SCH_FAC_INT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PS_SCH_FAC_INT
Subobject Name:
Status: VALID


Contains Facilities information that is setup at the unit offering pattern level. This information is used to create unit section and unit section occurrence level data.The corresponding production table is IGS_PS_UNIT_FACILITY.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export Scheduling Unit Offering Pattern Facilities Detail
Category: BUSINESS_ENTITY IGS_UNIT


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PS_SCH_FAC_INT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINT_FAC_ID
Columns
Name Datatype Length Mandatory Comments
INT_FAC_ID NUMBER
Yes Unique Identifier for each Unit Offering Pattern facilities in the Scheduler Interface.
INT_PAT_ID NUMBER
Yes Identifier for a Unit Offering Pattern in scheduling interface
MEDIA_CODE VARCHAR2 (10) Yes Media Code corresponding to the Unit Version of the Unit Offering Pattern.
MEDIA_DESCRIPTION VARCHAR2 (60) Yes Media 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_FAC_ID
,      INT_PAT_ID
,      MEDIA_CODE
,      MEDIA_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_SCH_FAC_INT;

Dependencies

[top of page]

IGS.IGS_PS_SCH_FAC_INT does not reference any database object

IGS.IGS_PS_SCH_FAC_INT is referenced by following:

SchemaAPPS
SynonymIGS_PS_SCH_FAC_INT