DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MRP_PLAN_JOBS_V

Object Details
Object Name: MRP_PLAN_JOBS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_PLAN_JOBS_V
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 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)
Query Text

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;

Dependencies

[top of page]

APPS.MRP_PLAN_JOBS_V references the following:

SchemaAPPS
ViewMRP_PLAN_ORGANIZATIONS_V
ViewMRP_WIP_JOBS_VIEW

APPS.MRP_PLAN_JOBS_V is not referenced by any database object