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.GME_INGRED_PICK_VW

Object Details

Object Name:	GME_INGRED_PICK_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_INGRED_PICK_VW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Ingredient Picking View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NO	VARCHAR2	(32)	Yes	Batch Number
BATCH_STATUS	NUMBER	(5)	Yes	Batch Status
ORGANIZATION_ID	NUMBER			Batch Organization
RECIPE_VALIDITY_RULE_ID	NUMBER	(10)		Batch Validity Rule
FORMULA_ID	NUMBER	(10)		Formula ID
ROUTING_ID	NUMBER	(10)		Routing ID
BATCH_ID	NUMBER	(10)	Yes	Batch ID
PLAN_START_DATE	DATE		Yes	Batch Plan Start Date
PLAN_CMPLT_DATE	DATE		Yes	Batch Plan Completion Date
ACTUAL_START_DATE	DATE			Batch Actual Start Date
LINE_NO	NUMBER	(5)	Yes	Ingredient Line Number
LINE_TYPE	NUMBER	(5)	Yes	Material Line Type
INVENTORY_ITEM_ID	NUMBER			Item ID
SUBINVENTORY	VARCHAR2	(10)		Supply Subinventory
LOCATOR_ID	NUMBER			Supply Locator
DTL_UM	VARCHAR2	(3)		Material Unit Of Measure
MATERIAL_REQUIREMENT_DATE	DATE			Material Requirement Date
BACKORDERED_QTY	NUMBER			Backordered Qty
MATERIAL_DETAIL_ID	NUMBER	(10)	Yes	Material Detail ID
REVISION	VARCHAR2	(3)		Item Revision
PLAN_QTY	NUMBER		Yes	Plan Qty
ACTUAL_QTY	NUMBER		Yes	Actual Qty
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Item Number
DESCRIPTION	VARCHAR2	(240)		Item Description
OPEN_QTY	NUMBER			Open Qty
BATCHSTEP_NO	NUMBER	(10)		Batchstep Number
OPRN_ID	NUMBER	(10)		Operation ID
OPRN_VERS	NUMBER	(5)		Operation Version
OPRN_NO	VARCHAR2	(16)		Operation Number

Query Text

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


SELECT BATCH_NO
,      BATCH_STATUS
,      ORGANIZATION_ID
,      RECIPE_VALIDITY_RULE_ID
,      FORMULA_ID
,      ROUTING_ID
,      BATCH_ID
,      PLAN_START_DATE
,      PLAN_CMPLT_DATE
,      ACTUAL_START_DATE
,      LINE_NO
,      LINE_TYPE
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      DTL_UM
,      MATERIAL_REQUIREMENT_DATE
,      BACKORDERED_QTY
,      MATERIAL_DETAIL_ID
,      REVISION
,      PLAN_QTY
,      ACTUAL_QTY
,      CONCATENATED_SEGMENTS
,      DESCRIPTION
,      OPEN_QTY
,      BATCHSTEP_NO
,      OPRN_ID
,      OPRN_VERS
,      OPRN_NO
FROM APPS.GME_INGRED_PICK_VW;

Dependencies

[top of page]

APPS.GME_INGRED_PICK_VW references the following:

APPS: GMD_OPERATIONS_B; GME_BATCH_HEADER; GME_BATCH_STEPS; GME_BATCH_STEP_ITEMS; GME_MATERIAL_DETAILS; GME_PICKING_PVT - show dependent code; MTL_SYSTEM_ITEMS_VL

APPS.GME_INGRED_PICK_VW is referenced by following:

APPS: GME_PICKING_PVT - show dependent code