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: GMP.GMP_SEQUENCE_DEPENDENCIES

Object Details

Object Name:	GMP_SEQUENCE_DEPENDENCIES
Object Type:	TABLE
Owner:	GMP
FND Design Data:	GMP.GMP_SEQUENCE_DEPENDENCIES
Subobject Name:
Status:	VALID

Table for Sequence Dependencies

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
OPRN_ID	NUMBER		Yes	The Surrogate Key for an Operation to be considered for sequence dependencies
FROM_CATEGORY_ID	NUMBER		Yes	The Sequence dependent Item Class for the item which was processed before the Current Item
TO_CATEGORY_ID	NUMBER		Yes	The Sequence dependent Item Class for the item which was processed after the last Item
SETUP_TIME	NUMBER		Yes	The amount of time to be added to the resources for operation of the later batch
PENALTY_FACTOR	NUMBER		Yes	the value to be used by WPS to discourage the operation from processing the different Item Classes after each other
FROM_SEQ_DEP_ID	NUMBER		Yes	the new surrogate to allow for the unique identification of combination of Operation and item class
TO_SEQ_DEP_ID	NUMBER		Yes	the new surrogate to allow for the unique identification of combination of Operation and item class
CREATION_DATE	DATE		Yes	Standard "Row Who" column
CREATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_DATE	DATE		Yes	Standard "Row Who" column
LAST_UPDATED_BY	NUMBER		Yes	Standard "Row Who" column
LAST_UPDATE_LOGIN	NUMBER			Standard "Row Who" column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Flex fields
ATTRIBUTE1	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE2	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE3	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE4	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE5	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE6	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE7	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE8	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE9	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE10	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE11	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE12	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE13	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE14	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE15	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE16	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE17	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE18	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE19	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE20	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE21	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE22	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE23	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE24	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE25	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE26	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE27	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE28	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE29	VARCHAR2	(240)		Standard Flex fields
ATTRIBUTE30	VARCHAR2	(240)		Standard Flex fields
TO_OPRN_ID	NUMBER			To Operation Identification

Query Text

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


SELECT OPRN_ID
,      FROM_CATEGORY_ID
,      TO_CATEGORY_ID
,      SETUP_TIME
,      PENALTY_FACTOR
,      FROM_SEQ_DEP_ID
,      TO_SEQ_DEP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      TO_OPRN_ID
FROM GMP.GMP_SEQUENCE_DEPENDENCIES;

Dependencies

[top of page]

GMP.GMP_SEQUENCE_DEPENDENCIES does not reference any database object

GMP.GMP_SEQUENCE_DEPENDENCIES is referenced by following:

GMP: GMP_SEQUENCE_DEPENDENCIES#