[Home] [Help] [Dependency Information]
Object Name: | MRP_WIP_REP_SCHD_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_WIP_REP_SCHD_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 |
---|---|---|---|---|
PRIMARY_ITEM_ID | NUMBER | Yes | Inventory item identifier of assembly the repetitive schedule creates | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
WIP_ENTITY_ID | NUMBER | Yes | WIP job or repetitive assembly identifier | |
REPETITIVE_SCHEDULE_ID | NUMBER | Yes | WIP repetitive schedule identifier | |
LINE_ID | NUMBER | Yes | Line identifier | |
FIRST_UNIT_START_DATE | DATE | Yes | First unit start date | |
FIRST_UNIT_COMPLETION_DATE | DATE | Yes | First unit completion date | |
LAST_UNIT_START_DATE | DATE | Yes | Last unit start date | |
LAST_UNIT_COMPLETION_DATE | DATE | Yes | Last unit completion date | |
PROCESSING_WORK_DAYS | NUMBER | Yes | Processing work days | |
DAILY_PRODUCTION_RATE | NUMBER | Yes | Schedule daily production rate | |
BOM_REVISION | VARCHAR2 | (3) | Inventory item revision code | |
STATUS_TYPE | NUMBER | Yes | Status of repetitive schedule | |
FIRM_PLANNED_FLAG | NUMBER | Yes | Control for MRP rescheduling | |
QUANTITY_COMPLETED | NUMBER | Yes | Current quantity completed on the schedule | |
FULL_LEAD_TIME | NUMBER | Yes | Assembly lead time | |
DEMAND_CLASS | VARCHAR2 | (30) | Schedule demand class |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_ITEM_ID
, COMPILE_DESIGNATOR
, ORGANIZATION_ID
, WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID
, LINE_ID
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, PROCESSING_WORK_DAYS
, DAILY_PRODUCTION_RATE
, BOM_REVISION
, STATUS_TYPE
, FIRM_PLANNED_FLAG
, QUANTITY_COMPLETED
, FULL_LEAD_TIME
, DEMAND_CLASS
FROM APPS.MRP_WIP_REP_SCHD_VIEW;
APPS.MRP_WIP_REP_SCHD_VIEW is not referenced by any database object
|
|
|