DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GME_BATCH_HEADER_V1

Object Details
Object Name: GME_BATCH_HEADER_V1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGME.GME_BATCH_HEADER_V1
Subobject Name:
Status: VALID

View Type

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


This view is created to maintain backward compatibility for other dependent modules. Batch/FPO header.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (10) Yes Unique Identifier for batches to FPO or batch.
PLANT_CODE VARCHAR2 (4)
Production organization in which the batch or FPO is/was/will be run.
BATCH_NO VARCHAR2 (32) Yes Batch or FPO number.
BATCH_TYPE NUMBER (5) Yes Differentiates between Firm Planned Order(10) and batches (0).
PROD_ID NUMBER (10)
Reserved for future use.
PROD_SEQUENCE NUMBER (5) Yes Reserved for future use. Batch sequence in campaign/prod order.
FORMULA_ID NUMBER (10)
FK to formula on which batch or FPO is based. This value can be derived from the Recipe_Validity_Rule_Id but
ROUTING_ID NUMBER (10)
FK to routing used.
PLAN_START_DATE DATE
Yes Planned release date/time for batch.
ACTUAL_START_DATE DATE

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 Required batch completion date/time, national.
EXPCT_CMPLT_DATE DATE
Yes Batch or FPO status. -3 = Converted FPO-1 = Cancelled1 = Pending2 = WIP3 = Certified 4 = Closed
ACTUAL_CMPLT_DATE DATE

Not currently used.
BATCH_STATUS NUMBER (5) Yes Batch or FPO status. -3 = Converted FPO -1 = Cancelled 1 = Pending 2 = WIP 3 = Certified 4 = Closed
PRIORITY_VALUE NUMBER
Yes Not currently used.
PRIORITY_CODE VARCHAR2 (4) Yes Not currently used.
PRINT_COUNT NUMBER (5) Yes Number of times batch ticket was printed.
IN_USE VARCHAR2 (0)
Not used anymore.
FMEFF_ID NUMBER (10)
Surrogate key to the Recipe Validity Rule Id the batch or FPO was based on.
FMCONTROL_CLASS VARCHAR2 (8)
Not currently used.
WIP_WHSE_CODE VARCHAR2 (4)
Warehouse used to cost production activity.
BATCH_CLOSE_DATE DATE

Date/time the batch was closed. Updated when the
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
DELETE_MARK NUMBER (5) Yes Standard: 0 = Active record (default) 1 = Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
PARENTLINE_ID NUMBER (10)
For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment category
Query Text

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


SELECT BATCH_ID
,      PLANT_CODE
,      BATCH_NO
,      BATCH_TYPE
,      PROD_ID
,      PROD_SEQUENCE
,      FORMULA_ID
,      ROUTING_ID
,      PLAN_START_DATE
,      ACTUAL_START_DATE
,      DUE_DATE
,      EXPCT_CMPLT_DATE
,      ACTUAL_CMPLT_DATE
,      BATCH_STATUS
,      PRIORITY_VALUE
,      PRIORITY_CODE
,      PRINT_COUNT
,      IN_USE
,      FMEFF_ID
,      FMCONTROL_CLASS
,      WIP_WHSE_CODE
,      BATCH_CLOSE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      PARENTLINE_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
,      ATTRIBUTE_CATEGORY
FROM APPS.GME_BATCH_HEADER_V1;

Dependencies

[top of page]

APPS.GME_BATCH_HEADER_V1 references the following:

SchemaAPPS
SynonymGME_BATCH_HEADER
APPS.GME_BATCH_HEADER_V1 is referenced by following:

SchemaAPPS
SynonymPM_BTCH_HDR