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

TABLE: GMP.PS_SCHD_FOR

Object Details
Object Name: PS_SCHD_FOR
Object Type: TABLE
Owner: GMP
FND Design Data: TableGMP.PS_SCHD_FOR
Subobject Name:
Status: VALID


Schedule forecast association. List of forecasts which are to be considered for this schedule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PS_SCHD_FOR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULE_ID
ColumnFORECAST_ID
PS_SCHD_FORI1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Yes Surrogate key for the schedule to which forecasts are associated.
FORECAST_ID NUMBER (10)
Surrogate key for the forecast which is associated to a schedule.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
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
ORGANIZATION_ID NUMBER

Organization ID of the forecast designator
FORECAST_DESIGNATOR VARCHAR2 (10)
Forecast Designator from Oracle Forecasting
Query Text

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


SELECT SCHEDULE_ID
,      FORECAST_ID
,      TEXT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      FORECAST_DESIGNATOR
FROM GMP.PS_SCHD_FOR;

Dependencies

[top of page]

GMP.PS_SCHD_FOR does not reference any database object

GMP.PS_SCHD_FOR is referenced by following:

SchemaGMP
ViewPS_SCHD_FOR#