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: ViewGME.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 (70)
Formula Description
ROUTING_NO VARCHAR2 (32)
Routing Number
ROUTING_VERS NUMBER (5)
Routing Version
ROUTING_DESC VARCHAR2 (40)
Routing Description
RECIPE_NO VARCHAR2 (32)
Recipe Number
RECIPE_VERSION NUMBER (5)
Recipe Version
RECIPE_DESCRIPTION VARCHAR2 (70)
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:

SchemaAPPS
SynonymFM_FORM_MST
SynonymFM_ROUT_HDR
PL/SQL PackageFND_DATE - show dependent code
SynonymFND_LOOKUP_VALUES
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymGMD_RECIPES
SynonymGMD_RECIPE_VALIDITY_RULES
SynonymGME_BATCH_HEADER
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_REASONS
APPS.GME_BATCH_HEADER_VW is referenced by following:

SchemaAPPS
Package BodyGME_ERES_UTILS - show dependent code
Package BodyGME_MOBILE_TXN - show dependent code
ViewGMF_SUBLEDGER_REP_V
ViewGMF_XLA_PM_RSRC_TXNS_V
ViewGMF_XLA_PM_TXNS_V
Package BodyGMO_CBR_GRP - show dependent code
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code
Package BodyINV_LABEL_PVT13 - show dependent code
ViewMTL_MFG_BATCHES_SECURITY_V