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]

VIEW: APPS.GMO_BATCH_STEPS_V

Object Details

Object Name:	GMO_BATCH_STEPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMO.GMO_BATCH_STEPS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(10)	Yes
BATCH_NO	VARCHAR2	(32)	Yes	BAtch No
BATCHSTEP_ID	NUMBER	(15)	Yes	Step ID
BATCHSTEP_NO	NUMBER	(10)	Yes	Step No
OPRN_ID	NUMBER	(10)	Yes	Operation Id
PLAN_STEP_QTY	NUMBER		Yes	Planned Qty
ACTUAL_STEP_QTY	NUMBER			Actual Step Quantity
STEP_QTY_UM	VARCHAR2	(0)		Actual Step UOM
PLAN_START_DATE	DATE			Planned Start Date
ACTUAL_START_DATE	DATE			ACtual Start Date
DUE_DATE	DATE		Yes	Due date
PLAN_CMPLT_DATE	DATE			Planned Completion Date
ACTUAL_CMPLT_DATE	DATE			Step Atual Completion date
STEP_CLOSE_DATE	DATE			Step Closure Date
STEP_STATUS	NUMBER	(5)	Yes	Step STatus
STEPRELEASE_TYPE	NUMBER	(5)	Yes	Step Release Type
MAX_STEP_CAPACITY	NUMBER			Maximun Step Capacity
MAX_STEP_CAPACITY_UM	VARCHAR2	(0)		Maximum Step capacity UOM
PLAN_CHARGES	NUMBER			Planned changes for the step
ACTUAL_CHARGES	NUMBER			Actual Chanrges for the step
QUALITY_STATUS	NUMBER	(1)		Quality Status of the step
MINIMUM_TRANSFER_QTY	NUMBER			Minimum Transfer Quantoty
TERMINATED_IND	NUMBER	(1)		Batch step TErminations indicator
OPRN_NO	VARCHAR2	(16)	Yes	Operation number
OPRN_VERS	NUMBER	(5)	Yes	Operation Version
OPRN_DESC	VARCHAR2	(240)	Yes	Operation Description
OPERATION	VARCHAR2	(57)		Conconated segment of Operation and version

Query Text

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


SELECT BATCH_ID
,      BATCH_NO
,      BATCHSTEP_ID
,      BATCHSTEP_NO
,      OPRN_ID
,      PLAN_STEP_QTY
,      ACTUAL_STEP_QTY
,      STEP_QTY_UM
,      PLAN_START_DATE
,      ACTUAL_START_DATE
,      DUE_DATE
,      PLAN_CMPLT_DATE
,      ACTUAL_CMPLT_DATE
,      STEP_CLOSE_DATE
,      STEP_STATUS
,      STEPRELEASE_TYPE
,      MAX_STEP_CAPACITY
,      MAX_STEP_CAPACITY_UM
,      PLAN_CHARGES
,      ACTUAL_CHARGES
,      QUALITY_STATUS
,      MINIMUM_TRANSFER_QTY
,      TERMINATED_IND
,      OPRN_NO
,      OPRN_VERS
,      OPRN_DESC
,      OPERATION
FROM APPS.GMO_BATCH_STEPS_V;

Dependencies

[top of page]

APPS.GMO_BATCH_STEPS_V references the following:

APPS: GMD_OPERATIONS_VL; GME_BATCH_HEADER; GME_BATCH_STEPS

APPS.GMO_BATCH_STEPS_V is referenced by following:

APPS: QA_PLAN_ELEMENT_API - show dependent code