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_BATCH_HEADER_VW

Object Details

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

View Type

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

Batch Header view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(10)	Yes	Unique Identifier for batches to FPO or batch
PLANT_CODE	VARCHAR2	(3)		Plant Code
ORGANIZATION_CODE	VARCHAR2	(3)		Production organization in which the batch or FPO is/was/will be run
BATCH_NO	VARCHAR2	(32)	Yes	Batch Number
BATCH_TYPE	NUMBER	(5)	Yes	FPO or Batch
PROD_ID	NUMBER	(10)		Not used
PROD_SEQUENCE	NUMBER	(5)	Yes	not used
RECIPE_VALIDITY_RULE_ID	NUMBER	(10)		Recipe Validity Rule ID
FORMULA_ID	NUMBER	(10)		Formula ID
ROUTING_ID	NUMBER	(10)		Routing ID
PLAN_START_DATE	DATE		Yes	Plan Start Date for the Batch
PLAN_START_DATE_DT	VARCHAR2	(4000)		Planned release date/time for batch
ACTUAL_START_DATE	DATE			Actual Start Date
ACTUAL_START_DATE_DT	VARCHAR2	(4000)		Actual start date/time for batch. Entered at the time the batch is released, can be entered by the user or current system date.
DUE_DATE	DATE		Yes	Due Date
ACTUAL_CMPLT_DATE	DATE			Actual Completion Date
ACTUAL_CMPLT_DATE_DT	VARCHAR2	(4000)		Actual completion date. This is updated at the time the batch is certified. The user can enter the date or the current system date is used
BATCH_STATUS	NUMBER	(5)	Yes	Batch Status Code
BATCH_STATUS_DESC	VARCHAR2	(80)		Batch Status
PRIORITY_VALUE	NUMBER		Yes	not used
PRIORITY_CODE	VARCHAR2	(4)	Yes	Not used
PRINT_COUNT	NUMBER	(5)	Yes	Print Count
FMCONTROL_CLASS	VARCHAR2	(8)		Formula Control Class
BATCH_CLOSE_DATE	DATE			Batch Close Date
BATCH_CLOSE_DATE_DT	VARCHAR2	(4000)		Date/time the batch was closed.
POC_IND	VARCHAR2	(1)		POC Indicator
ACTUAL_COST_IND	VARCHAR2	(1)		Actual Cost Indicator
GL_POSTED_IND	NUMBER	(5)	Yes	GL Posted Indicator
UPDATE_INVENTORY_IND	VARCHAR2	(1)		Update Inventory Indicator
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
DELETE_MARK	NUMBER	(5)	Yes	Delete Mark
TEXT_CODE	NUMBER	(10)		Text Code
PARENTLINE_ID	NUMBER	(10)		Parent Line ID. This is used for Phonatom Batch Functionality
FPO_ID	NUMBER	(10)		Firm Plan Order ID
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE31	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE32	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE33	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE34	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE35	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE36	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE37	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE38	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE39	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE40	VARCHAR2	(240)		Descriptive Flex Attribute
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Attribute Category
AUTOMATIC_STEP_CALCULATION	NUMBER	(5)	Yes	Automatic Step Qty. Calculation
PLAN_CMPLT_DATE	DATE		Yes	Planned batch completion date/time.
PLAN_CMPLT_DATE_DT	VARCHAR2	(4000)		Planned batch completion date/time. POC data is used to derive this date, the length of time required for each step is added to the planned start date/time. This is updated at the time the batch is created. If POC data is not specified then the lead times specified to the production rules are used to calculate the expected completion date.
FORMULA_NO	VARCHAR2	(32)		Formula Number
FORMULA_VERS	NUMBER			Formula Version
FORMULA_DESC1	VARCHAR2	(240)		Formula Description
ROUTING_NO	VARCHAR2	(32)		Routing Number
ROUTING_VERS	NUMBER	(5)		Routing Version
ROUTING_DESC	VARCHAR2	(240)		Routing Description
RECIPE_NO	VARCHAR2	(32)		Recipe Number
RECIPE_VERSION	NUMBER	(5)		Recipe Version
RECIPE_DESCRIPTION	VARCHAR2	(240)		Recipe Description
FIRMED_IND	NUMBER	(5)		Firmed Indicator
FINITE_SCHEDULED_IND	NUMBER	(5)		Finite Scheduled Indicator
ORDER_PRIORITY	NUMBER	(10)		order Priority
MIGRATED_BATCH_IND	VARCHAR2	(1)		Migrated Batch Indicator. This is to identify that batch is mograted.
ENFORCE_STEP_DEPENDENCY	NUMBER	(5)		Enforce Step Dependency
TERMINATED_IND	NUMBER	(1)		Termination Indicator
TERMINATED	VARCHAR2	(4000)		NULL if batch is not terminated. Value of Terminated(translated) when batch is terminated
TERMINATE_REASON	VARCHAR2	(30)		Reason for terminating the batch
LABORATORY_IND	NUMBER			=0 when batch is a production batch. =1 when batch is a laboratoty batch.
LABORATORY	VARCHAR2	(80)		=Production when batch is a production batch. =Laboratory when batch is a laboratoty batch. Translated
MOVE_ORDER_HEADER_ID	NUMBER			Unique identifer for invisisble move order header for the batch
ORGANIZATION_ID	NUMBER			Unique identifier for Production organization in which the batch or FPO is/was/will be run
DUE_DATE_DT	VARCHAR2	(4000)		Required batch completion date/time, national
ENHANCED_PI_IND	VARCHAR2	(1)		Enhanced Process Instructions Indicator

Query Text

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


SELECT BATCH_ID
,      PLANT_CODE
,      ORGANIZATION_CODE
,      BATCH_NO
,      BATCH_TYPE
,      PROD_ID
,      PROD_SEQUENCE
,      RECIPE_VALIDITY_RULE_ID
,      FORMULA_ID
,      ROUTING_ID
,      PLAN_START_DATE
,      PLAN_START_DATE_DT
,      ACTUAL_START_DATE
,      ACTUAL_START_DATE_DT
,      DUE_DATE
,      ACTUAL_CMPLT_DATE
,      ACTUAL_CMPLT_DATE_DT
,      BATCH_STATUS
,      BATCH_STATUS_DESC
,      PRIORITY_VALUE
,      PRIORITY_CODE
,      PRINT_COUNT
,      FMCONTROL_CLASS
,      BATCH_CLOSE_DATE
,      BATCH_CLOSE_DATE_DT
,      POC_IND
,      ACTUAL_COST_IND
,      GL_POSTED_IND
,      UPDATE_INVENTORY_IND
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TEXT_CODE
,      PARENTLINE_ID
,      FPO_ID
,      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
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ATTRIBUTE_CATEGORY
,      AUTOMATIC_STEP_CALCULATION
,      PLAN_CMPLT_DATE
,      PLAN_CMPLT_DATE_DT
,      FORMULA_NO
,      FORMULA_VERS
,      FORMULA_DESC1
,      ROUTING_NO
,      ROUTING_VERS
,      ROUTING_DESC
,      RECIPE_NO
,      RECIPE_VERSION
,      RECIPE_DESCRIPTION
,      FIRMED_IND
,      FINITE_SCHEDULED_IND
,      ORDER_PRIORITY
,      MIGRATED_BATCH_IND
,      ENFORCE_STEP_DEPENDENCY
,      TERMINATED_IND
,      TERMINATED
,      TERMINATE_REASON
,      LABORATORY_IND
,      LABORATORY
,      MOVE_ORDER_HEADER_ID
,      ORGANIZATION_ID
,      DUE_DATE_DT
,      ENHANCED_PI_IND
FROM APPS.GME_BATCH_HEADER_VW;

Dependencies

[top of page]

APPS.GME_BATCH_HEADER_VW references the following:

APPS: FM_FORM_MST; FM_ROUT_HDR; FND_DATE - show dependent code; FND_LOOKUP_VALUES; FND_MESSAGE - show dependent code; GMD_RECIPES; GMD_RECIPE_VALIDITY_RULES; GME_BATCH_HEADER; MTL_PARAMETERS; MTL_TRANSACTION_REASONS

APPS.GME_BATCH_HEADER_VW is referenced by following:

APPS: GME_ERES_UTILS - show dependent code; GME_MOBILE_TXN - show dependent code; GMF_SUBLEDGER_REP_V; GMF_XLA_PM_RSRC_TXNS_V; GMF_XLA_PM_TXNS_V; GMO_CBR_GRP - show dependent code; INV_GENEALOGY_REPORT_GEN - show dependent code; INV_LABEL_PVT13 - show dependent code; MTL_MFG_BATCHES_SECURITY_V