[Home] [Help] [Dependency Information]
Object Name: | MRP_PLAN_JOBS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_PLAN_JOBS_V |
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 | Yes | Organization identifier | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
PLANNED_ORGANIZATION | NUMBER | Planned organization | ||
WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly identifier | ||
WIP_ENTITY_NAME | VARCHAR2 | (240) | WIP job or repetitive assembly name | |
WIP_JOB_TYPE | NUMBER | WIP job type | ||
MPS_JOB_QUANTITY | NUMBER | MPS relief job quantity | ||
JOB_QUANTITY | NUMBER | Job quantity | ||
NET_QUANTITY | NUMBER | Number of assemblies netted to supply by MRP | ||
MPS_NET_QUANTITY | NUMBER | Quantity used by MRP to relieve MPS for the job(used by MRP only) | ||
MPS_SCHEDULED_COMPLETION_DATE | DATE | MPS relief updated job completion date | ||
SCHEDULED_COMPLETION_DATE | DATE | Scheduled 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 | |
DEMAND_CLASS | VARCHAR2 | (30) | Job demand class | |
STATUS_CODE | NUMBER | Job status code | ||
NET_WIP | NUMBER | Net WIP flag in plan options | ||
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_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate Bill of material designator | |
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing designator | |
FULL_PEGGING | NUMBER | Full pegging attribute for component | ||
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
, PLANNED_ORGANIZATION
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
, WIP_JOB_TYPE
, MPS_JOB_QUANTITY
, JOB_QUANTITY
, NET_QUANTITY
, MPS_NET_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
, DEMAND_CLASS
, STATUS_CODE
, NET_WIP
, PROJECT_ID
, TASK_ID
, SCHEDULE_GROUP_ID
, BUILD_SEQUENCE
, LINE_ID
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, FULL_PEGGING
, ENTITY_TYPE
, END_ITEM_UNIT_NUMBER
FROM APPS.MRP_PLAN_JOBS_V;
APPS.MRP_PLAN_JOBS_V is not referenced by any database object
|
|
|