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: GMO.GMO_BATCH_PROGRESSION

Object Details

Object Name:	GMO_BATCH_PROGRESSION
Object Type:	TABLE
Owner:	GMO
FND Design Data:	GMO.GMO_BATCH_PROGRESSION
Subobject Name:
Status:	VALID

This table maintains Batch Progression

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMO_BATCH_PROGRESSION_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESSION_ID
SYS_IL0000400887C00027$$	LOB	UNIQUE	APPS_TS_TX_DATA
GMO_BATCH_PROGRESSION_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRESSION_ID	NUMBER	(22)	Yes	Unique Identifier
BATCH_ID	NUMBER	(22)		Batch ID
BATCHSTEP_ID	NUMBER	(22)		Batch Step Identifier
MATERIAL_LINE_ID	NUMBER	(22)		Material Line Identifier
BATCHACTIVITY_ID	NUMBER	(22)		Batch Activity Identifier
BATCHRSRC_ID	NUMBER	(22)		Batch Activity Resource Identifier
DISPENSE_ID	NUMBER	(22)		Dispense Identifier
SAMPLE_ID	NUMBER	(22)		Sample Identifier
DEVIATION_ID	NUMBER	(22)		Deviation Identifier
TRANSACTION_ID	NUMBER	(22)		Transaction Identifier
PARENT_NODE	VARCHAR2	(200)		Parent Node under which current XML or text output need to be placed
PARENT_KEY_NODE	VARCHAR2	(200)		Parent XML record Identifier Node
PARENT_KEY_VAL	VARCHAR2	(200)		Parent Node Identifier Value
CURR_NODE_KEY	VARCHAR2	(200)		Current XML record Identifier Node
CURR_KEY_VAL	VARCHAR2	(200)		Current Node Identifier Value
USER_KEY_LABEL_PROD	VARCHAR2	(10)		User Key Label Message Token Owner Product Code
USER_KEY_LABEL_TOKEN	VARCHAR2	(200)		User Key Label Message Token
USER_KEY_LABEL	VARCHAR2	(2000)		User key Label from eRecord
USER_KEY_VALUE	VARCHAR2	(2000)		User Visual record Identifier
EXTERNAL_EVENT	VARCHAR2	(2000)		External Event Flag It will contain value of Y or N
INCLUDE_IN_CBR	VARCHAR2	(100)		This identifies CLOB Column value is XML or Text
EVENT	VARCHAR2	(200)		Event occured in batch progression
EVENT_KEY	VARCHAR2	(200)		ERES event Key
EVENT_DATE	DATE			Event Date
PLANED_START_DATE	DATE			Planed Start Date of the Event
ERECORD_ID	NUMBER	(22)		Evidence Store Document ID
XML_EREC	CLOB	(4000)		CLOB this will hold XML or Text Output
STATUS	VARCHAR2	(200)		Evnet Status
INCLUDED_IN_CBR	VARCHAR2	(1)		This contains value Y or N. N means not included. Y means included
XML_MAP_CODE	VARCHAR2	(40)		If XML need to be transformed further
COMPARE_XML	VARCHAR2	(1)		This column holds whether to compare XML or Not

Query Text

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


SELECT PROGRESSION_ID
,      BATCH_ID
,      BATCHSTEP_ID
,      MATERIAL_LINE_ID
,      BATCHACTIVITY_ID
,      BATCHRSRC_ID
,      DISPENSE_ID
,      SAMPLE_ID
,      DEVIATION_ID
,      TRANSACTION_ID
,      PARENT_NODE
,      PARENT_KEY_NODE
,      PARENT_KEY_VAL
,      CURR_NODE_KEY
,      CURR_KEY_VAL
,      USER_KEY_LABEL_PROD
,      USER_KEY_LABEL_TOKEN
,      USER_KEY_LABEL
,      USER_KEY_VALUE
,      EXTERNAL_EVENT
,      INCLUDE_IN_CBR
,      EVENT
,      EVENT_KEY
,      EVENT_DATE
,      PLANED_START_DATE
,      ERECORD_ID
,      XML_EREC
,      STATUS
,      INCLUDED_IN_CBR
,      XML_MAP_CODE
,      COMPARE_XML
FROM GMO.GMO_BATCH_PROGRESSION;

Dependencies

[top of page]

GMO.GMO_BATCH_PROGRESSION does not reference any database object

GMO.GMO_BATCH_PROGRESSION is referenced by following:

APPS: GMO_BATCH_PROGRESSION