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

TABLE: GMP.GMP_ROUTING_OFFSETS

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


Table for Routing offsets used in Lead Time Calculations


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLANT_CODE VARCHAR2 (4)
Column Identifies the OPM Plant
FMEFF_ID NUMBER (15) Yes Column Identifies the Effectivity Id, Surrogate Key for the Effectivity Row
RECIPE_ID NUMBER (15) Yes Unique identifier for a Recipe
FORMULA_ID NUMBER (10) Yes The Formula ID associated with this Recipe. A Formula is required in order to create a Recipe
ROUTING_ID NUMBER (15) Yes The Routing ID associated with this Recipe. It is optional to associate a Routing with a Recipe
ROUTINGSTEP_ID NUMBER (10) Yes Surrogate key for the routing step
START_OFFSET NUMBER
Yes Column identifies the Starting Offset
END_OFFSET NUMBER
Yes Column identifies the End Offset
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
ORGANIZATION_ID NUMBER

Organization Id
Query Text

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


SELECT PLANT_CODE
,      FMEFF_ID
,      RECIPE_ID
,      FORMULA_ID
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      START_OFFSET
,      END_OFFSET
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
FROM GMP.GMP_ROUTING_OFFSETS;

Dependencies

[top of page]

GMP.GMP_ROUTING_OFFSETS does not reference any database object

GMP.GMP_ROUTING_OFFSETS is referenced by following:

SchemaAPPS
SynonymGMP_ROUTING_OFFSETS