[Home] [Help] [Dependency Information]
Object Name: | MRP_WIP_JOBS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_WIP_JOBS_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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) |
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;
|
|
|