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

Object Details

Object Name:	MTL_WORK_ORDER_HEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_WORK_ORDER_HEADER_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
WIP_ENTITY_ID	NUMBER		WIP Entity Identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	WIP Entity Name
ORGANIZATION_ID	NUMBER		Organization Identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
ORGANIZATION_NAME	VARCHAR2	(240)	Organization Name
BATCH_STATUS	NUMBER		Batch or FPO status. -3 = Converted FPO, -1 = Cancelled, 1 = Pending, 2 = WIP, 3 = Completed, 4 = Closed
STATUS_TYPE	VARCHAR2	(80)	Batch Status Type
ITEM_NUMBER	VARCHAR2	(40)	Item name
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
INVENTORY_ITEM_ID	NUMBER		Invnetory Item Identifier
FIRM_PLANNED_FLAG	NUMBER		Control for MRP rescheduling
CLASS_CODE	VARCHAR2	(10)	Accounting class associated with job
SCHEDULED_START_DATE	DATE		Date on which job is scheduled to start
DATE_RELEASED	DATE		Date on which job is released
SCHEDULED_COMPLETION_DATE	DATE		Last unit scheduled completion date
DATE_COMPLETED	DATE		Last unit actual completion date
DATE_CLOSED	DATE		Date on which job was closed
START_QUANTITY	NUMBER		Job start quantity
QUANTITY_REMAINING	VARCHAR2	(40)	Remaining Quantity
QUANTITY_COMPLETED	VARCHAR2	(40)	Current job quantity completed
QUANTITY_SCRAPPED	VARCHAR2	(40)	Number of units scrapped on the current job
NET_QUANTITY	NUMBER		Number of assemblies netted to supply by MRP
COMPLETION_SUBINVENTORY	VARCHAR2	(10)	Default completion subinventory for assemblies completed by the job
JOB_TYPE	NUMBER		Type of discrete job
WORK_ORDER_TYPE	VARCHAR2	(5)	Specifies whether the work order is JOB or BATCH
LINE_TYPE	CHAR	(7)	Specifies Line Type as Product
LOT_NUMBER	VARCHAR2	(80)	Lot Number
DISABLE_FLAG	NUMBER		Disable flag
EXPIRATION_DATE	DATE		Lot expiration date
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
SUPPLIER_LOT_NUMBER	VARCHAR2	(150)	Lot number given by the supplier for PO receipts - Used By WMS Only
GRADE_CODE	VARCHAR2	(150)	Grade Code - Used By WMS Only
ORIGINATION_DATE	DATE		Lot creation date (as in the BRD) - Used By WMS Only
DATE_CODE	VARCHAR2	(150)	Date Code - Used By WMS Only
STATUS_ID	NUMBER		Status identifier - Used by WMS only
CHANGE_DATE	DATE		Last modified date (as in the BRD) - Used By WMS Only
AGE	NUMBER		The age of the lot or sublot in days after the creation date - Used By WMS Only
RETEST_DATE	DATE		Retest date - Used By WMS Only
MATURITY_DATE	DATE		The date on which the item matures - Used By WMS Only
ITEM_SIZE	NUMBER		The size of a given product, determined by visual inspection. - Used By WMS Only
COLOR	VARCHAR2	(150)	Color- Used By WMS Only
VOLUME	NUMBER		The volume of the lot or sublot- Used By WMS Only
VOLUME_UOM	VARCHAR2	(3)	When defining the volume attribute the ability to identify a volume unit of measure such as cubic inches or cubic centimeters should also be included. - Used By WMS Only
PLACE_OF_ORIGIN	VARCHAR2	(150)	Country of Origin- Used By WMS Only
BEST_BY_DATE	DATE		The date on or before which the lot or sublot is best used.- Used By WMS Only
LENGTH	NUMBER		The length dimension of the lot or sublot.- Used By WMS Only
LENGTH_UOM	VARCHAR2	(3)	Unit of measure for measuring lenght- Used By WMS Only
RECYCLED_CONTENT	NUMBER		The content, usually expressed as a percentage, of the product that is made up of recycled materials- Used By WMS Only
THICKNESS	NUMBER		The thickness dimension of the lot.- Used By WMS Only
THICKNESS_UOM	VARCHAR2	(3)	UOM to measure thickness- Used By WMS Only
WIDTH	NUMBER		The width dimension of the lot.- Used By WMS Only
WIDTH_UOM	VARCHAR2	(3)	UOM to measure width dimension of the lot.- Used By WMS Only
CURL_WRINKLE_FOLD	VARCHAR2	(150)	This attribute is used in the pulp and paper industry to identify potential problems when feeding the paper through machinery.
LOT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Lot attributes descriptive flexfield structure defining column
C_ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE6	VARCHAR2	(150)	DescriptiveDescriptive flexfield segment flexfield segment
C_ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE16	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE17	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE18	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE19	VARCHAR2	(150)	Descriptive flexfield segment
C_ATTRIBUTE20	VARCHAR2	(150)	Descriptive flexfield segment
D_ATTRIBUTE1	DATE		Descriptive flexfield segment
D_ATTRIBUTE2	DATE		Descriptive flexfield segment
D_ATTRIBUTE3	DATE		Descriptive flexfield segment
D_ATTRIBUTE4	DATE		Descriptive flexfield segment
D_ATTRIBUTE5	DATE		Descriptive flexfield segment
D_ATTRIBUTE6	DATE		Descriptive flexfield segment
D_ATTRIBUTE7	DATE		Descriptive flexfield segment
D_ATTRIBUTE8	DATE		Descriptive flexfield segment
D_ATTRIBUTE9	DATE		Descriptive flexfield segment
D_ATTRIBUTE10	DATE		Descriptive flexfield segment
N_ATTRIBUTE1	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE2	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE3	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE4	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE5	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE6	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE7	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE8	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE9	NUMBER		Descriptive flexfield segment
N_ATTRIBUTE10	NUMBER		Descriptive flexfield segment
VENDOR_ID	NUMBER		Supplier identification (from po_vendors table)
TERRITORY_CODE	VARCHAR2	(30)	Territory Code for Country of Origin
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment

Query Text

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


SELECT WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      BATCH_STATUS
,      STATUS_TYPE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_ID
,      FIRM_PLANNED_FLAG
,      CLASS_CODE
,      SCHEDULED_START_DATE
,      DATE_RELEASED
,      SCHEDULED_COMPLETION_DATE
,      DATE_COMPLETED
,      DATE_CLOSED
,      START_QUANTITY
,      QUANTITY_REMAINING
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      NET_QUANTITY
,      COMPLETION_SUBINVENTORY
,      JOB_TYPE
,      WORK_ORDER_TYPE
,      LINE_TYPE
,      LOT_NUMBER
,      DISABLE_FLAG
,      EXPIRATION_DATE
,      VENDOR_NAME
,      SUPPLIER_LOT_NUMBER
,      GRADE_CODE
,      ORIGINATION_DATE
,      DATE_CODE
,      STATUS_ID
,      CHANGE_DATE
,      AGE
,      RETEST_DATE
,      MATURITY_DATE
,      ITEM_SIZE
,      COLOR
,      VOLUME
,      VOLUME_UOM
,      PLACE_OF_ORIGIN
,      BEST_BY_DATE
,      LENGTH
,      LENGTH_UOM
,      RECYCLED_CONTENT
,      THICKNESS
,      THICKNESS_UOM
,      WIDTH
,      WIDTH_UOM
,      CURL_WRINKLE_FOLD
,      LOT_ATTRIBUTE_CATEGORY
,      C_ATTRIBUTE1
,      C_ATTRIBUTE2
,      C_ATTRIBUTE3
,      C_ATTRIBUTE4
,      C_ATTRIBUTE5
,      C_ATTRIBUTE6
,      C_ATTRIBUTE7
,      C_ATTRIBUTE8
,      C_ATTRIBUTE9
,      C_ATTRIBUTE10
,      C_ATTRIBUTE11
,      C_ATTRIBUTE12
,      C_ATTRIBUTE13
,      C_ATTRIBUTE14
,      C_ATTRIBUTE15
,      C_ATTRIBUTE16
,      C_ATTRIBUTE17
,      C_ATTRIBUTE18
,      C_ATTRIBUTE19
,      C_ATTRIBUTE20
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      VENDOR_ID
,      TERRITORY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.MTL_WORK_ORDER_HEADER_V;

Dependencies

[top of page]

APPS.MTL_WORK_ORDER_HEADER_V references the following:

APPS: GEM_LOOKUPS; GME_BATCH_HEADER; GME_MATERIAL_DETAILS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MTL_LOT_NUMBERS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; PJM_PROJECT - show dependent code; WIP_DISCRETE_JOBS_V; WIP_ENTITIES

APPS.MTL_WORK_ORDER_HEADER_V is referenced by following:

APPS: INV_GENEALOGY_REPORT_GEN - show dependent code