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

TABLE: GMP.GMP_RSRC_UNAVAIL_MAN

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


Manual Entries Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMP_RSRC_UNAVAIL_MAN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_DATE
ColumnTO_DATE
ColumnRESOURCE_ID
ColumnINSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Surrogate Key for Exception set
FROM_DATE DATE
Yes Start Date-time ofUnavailable time
TO_DATE DATE
Yes End Date-time of Unavailabletime
REASON_CODE VARCHAR2 (30) Yes Code for Unavailable reason. FKto SY_REAS_CDS
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
RESOURCE_UNITS NUMBER

Number of Resources that are Not Available
INSTANCE_ID NUMBER
Yes Surrogate key which uniquely indentifies the instance of a resource. This comes from the sequence GMP_RESOURCE_INSTANCES_S.
MAINT_ORG_ID NUMBER

This column identifies the Maintenance Organization id for the work order number in eAM
WIP_ENTITY_ID NUMBER

This column identifies the work order number in eAM
OP_SEQ NUMBER

This column identifies Operation Sequence Number
Query Text

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


SELECT RESOURCE_ID
,      FROM_DATE
,      TO_DATE
,      REASON_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_UNITS
,      INSTANCE_ID
,      MAINT_ORG_ID
,      WIP_ENTITY_ID
,      OP_SEQ
FROM GMP.GMP_RSRC_UNAVAIL_MAN;

Dependencies

[top of page]

GMP.GMP_RSRC_UNAVAIL_MAN does not reference any database object

GMP.GMP_RSRC_UNAVAIL_MAN is referenced by following:

SchemaGMP
ViewGMP_RSRC_UNAVAIL_MAN#