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: GML.GML_BATCH_SO_WORKFLOW

Object Details

Object Name:	GML_BATCH_SO_WORKFLOW
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.GML_BATCH_SO_WORKFLOW
Subobject Name:
Status:	VALID

OM Batch reservation workflow

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_BATCH_SO_WORKFLOW_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	WF_ITEM_ID
GML_BATCH_SO_WORKFLOW_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SO_HEADER_ID
GML_BATCH_SO_WORKFLOW_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SO_LINE_ID
GML_BATCH_SO_WORKFLOW_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BATCH_ID
GML_BATCH_SO_WORKFLOW_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BATCH_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WF_ITEM_ID	NUMBER	(15)	Yes	Primary Key
WF_ITEM_TYPE	VARCHAR2	(30)		Workflow Item Type
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Item Key
SO_HEADER_ID	NUMBER	(15)		Reference to OE_ORDER_HEADERS_ALL.HEADER_ID
SO_LINE_ID	NUMBER	(15)		Reference to OE_ORDER_LINES_ALL.LINE_ID
BATCH_ID	NUMBER	(15)		Reference to GME_BATCH_HEADER.BATCH_ID
BATCH_LINE_ID	NUMBER	(15)		Reference to GME_MATERIAL_DETAILS.MATERIAL_DETAIL_ID
ACTION_CODE	VARCHAR2	(200)		The action code that trigged the workflow
CREATION_DATE	DATE		Yes	The date record is created
CREATED_BY	NUMBER	(15)	Yes	User Id who created the record
PROGRAM_APPLICATION_ID	NUMBER			Program application ID
PROGRAM_ID	NUMBER			Program ID
LAST_UPDATED_BY	NUMBER	(15)	Yes	User Id who last updated the record
LAST_UPDATE_DATE	DATE		Yes	The date record is last updated

Query Text

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


SELECT WF_ITEM_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      SO_HEADER_ID
,      SO_LINE_ID
,      BATCH_ID
,      BATCH_LINE_ID
,      ACTION_CODE
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM GML.GML_BATCH_SO_WORKFLOW;

Dependencies

[top of page]

GML.GML_BATCH_SO_WORKFLOW does not reference any database object

GML.GML_BATCH_SO_WORKFLOW is referenced by following:

APPS: GML_BATCH_SO_WORKFLOW