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

Object Details

Object Name:	WIP_DISCRETE_JOBS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_DISCRETE_JOBS_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	Mandatory	Comments
ROW_ID	ROWID	(10)		The ROWID from WIP_DISCRETE_JOBS
WIP_ENTITY_ID	NUMBER		Yes	WIP job identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	Yes	WIP job or repetitive assembly name
WE_ROW_ID	ROWID	(10)		The ROWID from WIP_ENTITIES
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
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		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Extended Who column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who column
PROGRAM_ID	NUMBER			Extended Who column
PROGRAM_UPDATE_DATE	DATE			Extended Who column
DESCRIPTION	VARCHAR2	(240)		Descriptive text
STATUS_TYPE	NUMBER		Yes	Status of job
PRIMARY_ITEM_ID	NUMBER			Inventory item identifier of assembly the job creates
FIRM_PLANNED_FLAG	NUMBER		Yes	Control for MRP rescheduling
JOB_TYPE	NUMBER		Yes	Type of discrete job
JOB_TYPE_MEANING	VARCHAR2	(80)	Yes
WIP_SUPPLY_TYPE	NUMBER		Yes	Method of material consumption within WIP
CLASS_CODE	VARCHAR2	(10)	Yes	Accounting class associated with job
MATERIAL_ACCOUNT	NUMBER			General ledger account to accumulate material charges for a job
MATERIAL_OVERHEAD_ACCOUNT	NUMBER			General ledger account to accumulate material overhead charges for a job
RESOURCE_ACCOUNT	NUMBER			General ledger account to accumulate resource charges for a job
OUTSIDE_PROCESSING_ACCOUNT	NUMBER			General ledger account to accumulate outside processing charges for a job
MATERIAL_VARIANCE_ACCOUNT	NUMBER			General ledger account to accumulate material variances for a job
RESOURCE_VARIANCE_ACCOUNT	NUMBER			General ledger account to accumulate resource variances for a job
OUTSIDE_PROC_VARIANCE_ACCOUNT	NUMBER			General ledger account to accumulate outside processing variances for a job
STD_COST_ADJUSTMENT_ACCOUNT	NUMBER			General ledger account to accumulate standard cost variances for a job
OVERHEAD_ACCOUNT	NUMBER			General ledger account to accumulate overhead charges for a job
OVERHEAD_VARIANCE_ACCOUNT	NUMBER			General ledger account to accumulate overhead variances for a job
SCHEDULED_START_DATE	DATE		Yes	Date on which job is scheduled to start
DATE_RELEASED	DATE			Date on which job is released
SCHEDULED_COMPLETION_DATE	DATE		Yes	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		Yes	Job start quantity
QUANTITY_REMAINING	VARCHAR2	(40)		Quantity of the job that is not completed or scrapped
QUANTITY_COMPLETED	VARCHAR2	(40)		Quantity of the job that is completed
QUANTITY_SCRAPPED	VARCHAR2	(40)		Quantity of the job that is scrapped
NET_QUANTITY	NUMBER		Yes	Number of assemblies netted to supply by MRP
BOM_REFERENCE_ID	NUMBER			Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID	NUMBER			Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID	NUMBER			Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID	NUMBER			Routing identifier when a common routing is used
BOM_REVISION	VARCHAR2	(3)		Inventory item revision code
ROUTING_REVISION	VARCHAR2	(3)		Routing revision code
BOM_REVISION_DATE	DATE			Date of inventory item revision used to explode the bill of materials used in the job
ROUTING_REVISION_DATE	DATE			Routing revision date
LOT_NUMBER	VARCHAR2	(80)		Default lot number to assign to assemblies completed from the job
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate bill of material used in a job
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing used in a job
COMPLETION_SUBINVENTORY	VARCHAR2	(10)		Default completion subinventory for assemblies completed by the job
COMPLETION_LOCATOR_ID	NUMBER			Default completion locator identifier for assemblies completed by the job
SUB_LOCATOR_CONTROL	NUMBER			Subinventory Locator Control
DEMAND_CLASS	VARCHAR2	(30)		Classification of demand for which the job will supply
SCHEDULE_GROUP_NAME	VARCHAR2	(30)		Schedule Group Name
SCHEDULE_GROUP_ID	NUMBER			Schedule Group ID
BUILD_SEQUENCE	NUMBER			Build Sequence
LINE_CODE	VARCHAR2	(10)		Line Code
LINE_ID	NUMBER			Line ID
PROJECT_NAME	VARCHAR2	(4000)		Project Name
PROJECT_NUMBER	VARCHAR2	(4000)		Project Number
PROJECT_ID	NUMBER			Project ID
TASK_NAME	VARCHAR2	(4000)		Task Name
TASK_NUMBER	VARCHAR2	(4000)		Task Number
TASK_ID	NUMBER			Task ID
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
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
STATUS_TYPE_DISP	VARCHAR2	(80)	Yes	Displayed value for job status
WIP_SUPPLY_TYPE_DISP	VARCHAR2	(80)	Yes	Displayed value for WIP supply type
OVERCOMPLETION_TOLERANCE_TYPE	NUMBER
OVERCOMPLETION_TOLERANCE_VALUE	NUMBER
KANBAN_CARD_ID	NUMBER
KANBAN_CARD_NUMBER	VARCHAR2	(200)		Name of the kanban card
PO_CREATION_TIME	NUMBER
PRIORITY	NUMBER			Scheduling Priority
DUE_DATE	DATE
EST_SCRAP_ACCOUNT	NUMBER
EST_SCRAP_VAR_ACCOUNT	NUMBER
ENTITY_TYPE	NUMBER		Yes
DUE_DATE_PENALTY	NUMBER
DUE_DATE_TOLERANCE	NUMBER
COPRODUCTS_SUPPLY	NUMBER
REQUESTED_START_DATE	DATE
SERIALIZATION_START_OP	NUMBER
ACTUAL_START_DATE	DATE			An actual job start date.
EXPECTED_HOLD_RELEASE_DATE	DATE			An expected date to release job from on hold.

Query Text

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


SELECT ROW_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WE_ROW_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESCRIPTION
,      STATUS_TYPE
,      PRIMARY_ITEM_ID
,      FIRM_PLANNED_FLAG
,      JOB_TYPE
,      JOB_TYPE_MEANING
,      WIP_SUPPLY_TYPE
,      CLASS_CODE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      MATERIAL_VARIANCE_ACCOUNT
,      RESOURCE_VARIANCE_ACCOUNT
,      OUTSIDE_PROC_VARIANCE_ACCOUNT
,      STD_COST_ADJUSTMENT_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OVERHEAD_VARIANCE_ACCOUNT
,      SCHEDULED_START_DATE
,      DATE_RELEASED
,      SCHEDULED_COMPLETION_DATE
,      DATE_COMPLETED
,      DATE_CLOSED
,      START_QUANTITY
,      QUANTITY_REMAINING
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      NET_QUANTITY
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      BOM_REVISION
,      ROUTING_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      LOT_NUMBER
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      SUB_LOCATOR_CONTROL
,      DEMAND_CLASS
,      SCHEDULE_GROUP_NAME
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      LINE_CODE
,      LINE_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PROJECT_ID
,      TASK_NAME
,      TASK_NUMBER
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STATUS_TYPE_DISP
,      WIP_SUPPLY_TYPE_DISP
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      KANBAN_CARD_ID
,      KANBAN_CARD_NUMBER
,      PO_CREATION_TIME
,      PRIORITY
,      DUE_DATE
,      EST_SCRAP_ACCOUNT
,      EST_SCRAP_VAR_ACCOUNT
,      ENTITY_TYPE
,      DUE_DATE_PENALTY
,      DUE_DATE_TOLERANCE
,      COPRODUCTS_SUPPLY
,      REQUESTED_START_DATE
,      SERIALIZATION_START_OP
,      ACTUAL_START_DATE
,      EXPECTED_HOLD_RELEASE_DATE
FROM APPS.WIP_DISCRETE_JOBS_V;

Dependencies

[top of page]

APPS.WIP_DISCRETE_JOBS_V references the following:

APPS: MFG_LOOKUPS; MTL_KANBAN_CARDS; MTL_SECONDARY_INVENTORIES; PJM_PROJECT - show dependent code; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_LINES; WIP_SCHEDULE_GROUPS

APPS.WIP_DISCRETE_JOBS_V is referenced by following:

APPS: MTL_WORK_ORDER_HEADER_V; WSM_WIP_GENEALOGY_LOTATTR_V; WSM_WIP_GENEALOGY_V