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

Object Details

Object Name:	MRP_WIP_JOBS_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_WIP_JOBS_VIEW
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
ORGANIZATION_ID	NUMBER		Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	MPS, MRP or DRP plan identifier
WIP_ENTITY_ID	NUMBER		WIP job or repetitive assembly identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	WIP job or repetitive assembly name
MPS_NET_QUANTITY	NUMBER		Quantity used by MRP to relieve MPS for the job (used by MRP only)
MPS_JOB_QUANTITY	NUMBER		MPS relief job quantity
NET_QUANTITY	NUMBER		Number of assemblies netted to supply by MRP
JOB_QUANTITY	NUMBER		Job quantity
MPS_SCHEDULED_COMPLETION_DATE	DATE		MPS relief updated job completion date
SCHEDULED_COMPLETION_DATE	DATE		Job completion date
QUANTITY_SCRAPPED	NUMBER		Current job scrapped units
QUANTITY_COMPLETED	NUMBER		Current job quantity complete
MPS_EXPECTED_SCRAP_QUANTITY	NUMBER		MPS relief updated expected scrap quantity
EXPECTED_SCRAP_QUANTITY	NUMBER		Expected scrap quantity
FIRM_PLANNED_STATUS_TYPE	NUMBER		Firm planned type
START_DATE	DATE		Job start date
REVISION	VARCHAR2	(3)	Item revision
STATUS_CODE	NUMBER		Job status code
WIP_JOB_TYPE	NUMBER		Job type
DEMAND_CLASS	VARCHAR2	(30)	Job demand class
FULL_PEGGING	NUMBER		Full pegging attribute for component
PROJECT_ID	NUMBER		Project identifier
TASK_ID	NUMBER		Task identifier
SCHEDULE_GROUP_ID	NUMBER		Schedule group identifier
BUILD_SEQUENCE	NUMBER		Build sequence
LINE_ID	NUMBER		Line identifier
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)	Alternate routing designator
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)	Alternate bom designator
ENTITY_TYPE	NUMBER		WIP entity type
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      MPS_NET_QUANTITY
,      MPS_JOB_QUANTITY
,      NET_QUANTITY
,      JOB_QUANTITY
,      MPS_SCHEDULED_COMPLETION_DATE
,      SCHEDULED_COMPLETION_DATE
,      QUANTITY_SCRAPPED
,      QUANTITY_COMPLETED
,      MPS_EXPECTED_SCRAP_QUANTITY
,      EXPECTED_SCRAP_QUANTITY
,      FIRM_PLANNED_STATUS_TYPE
,      START_DATE
,      REVISION
,      STATUS_CODE
,      WIP_JOB_TYPE
,      DEMAND_CLASS
,      FULL_PEGGING
,      PROJECT_ID
,      TASK_ID
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      LINE_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      ENTITY_TYPE
,      END_ITEM_UNIT_NUMBER
FROM APPS.MRP_WIP_JOBS_VIEW;

Dependencies

[top of page]

APPS.MRP_WIP_JOBS_VIEW references the following:

APPS: MRP_SYSTEM_ITEMS; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_FLOW_SCHEDULES

APPS.MRP_WIP_JOBS_VIEW is referenced by following:

APPS: MRP_PLAN_JOBS_V