[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

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

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

INV_GENEALOGY_REPORT_GEN - show dependent code