[Home] [Help] [Dependency Information]
Object Name: | EAM_FORECAST_WO |
---|---|
Object Type: | TABLE |
Owner: | EAM |
FND Design Data: | EAM.EAM_FORECAST_WO |
Subobject Name: | |
Status: | VALID |
This table stores the operation level information for forecasted work orders for eAM maintenance budgeting and forecasting. It mirrors the structure of wip_operations.
WIP_OPERATIONS stores information about job and repetitive schedule
operations. Each row represents a specific operation and includes
an operation sequence number, which orders the operations for the job or
repetitive schedule. Each row also includes the assembly quantity
completed at an operation, the quantity at each intraoperation step,
the department associated with an operation, the scheduled start and
completion dates for an operation, the operation's countpoint and
backflush types and other operation attributes. In general, Oracle
Work in Process uses this information to control and monitor assembly
production on the shop floor.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WIP_ENTITY_ID | NUMBER | Yes | WIP job or schedule Identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number within a routing | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
REPETITIVE_SCHEDULE_ID | NUMBER | WIP repetitive schedule Identifier | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Enhanced Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who column | ||
PROGRAM_ID | NUMBER | Enhanced Who column | ||
PROGRAM_UPDATE_DATE | DATE | Enhanced Who column | ||
OPERATION_SEQUENCE_ID | NUMBER | Operation sequence Identifier | ||
STANDARD_OPERATION_ID | NUMBER | Standard operation Identifier | ||
DEPARTMENT_ID | NUMBER | Yes | Department Identifier | |
DESCRIPTION | VARCHAR2 | (240) | Descriptive text | |
SCHEDULED_QUANTITY | NUMBER | Yes | Number of units scheduled for the operation | |
QUANTITY_IN_QUEUE | NUMBER | Yes | Number of units in Queue of the operation | |
QUANTITY_RUNNING | NUMBER | Yes | Number of units in To Run of the operation | |
QUANTITY_WAITING_TO_MOVE | NUMBER | Yes | Number of units waiting To Move in the operation | |
QUANTITY_REJECTED | NUMBER | Yes | Number of units rejected from the operation | |
QUANTITY_SCRAPPED | NUMBER | Yes | Number of units scrapped from the operation | |
QUANTITY_COMPLETED | NUMBER | Yes | Number of units completed by the operation | |
FIRST_UNIT_START_DATE | DATE | Yes | First unit scheduled receipt date | |
FIRST_UNIT_COMPLETION_DATE | DATE | Yes | First unit scheduled completion date | |
LAST_UNIT_START_DATE | DATE | Yes | Last unit scheduled receipt date | |
LAST_UNIT_COMPLETION_DATE | DATE | Yes | Last unit scheduled completion date | |
PREVIOUS_OPERATION_SEQ_NUM | NUMBER | Previous operation sequence number | ||
NEXT_OPERATION_SEQ_NUM | NUMBER | Next operation sequence number | ||
COUNT_POINT_TYPE | NUMBER | Yes | Operation move type | |
BACKFLUSH_FLAG | NUMBER | Yes | Backflush control code | |
MINIMUM_TRANSFER_QUANTITY | NUMBER | Yes | Minimum operation transfer quantity | |
DATE_LAST_MOVED | DATE | Operation last move date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
WF_ITEMTYPE | VARCHAR2 | (8) | Workflow Item Type | |
WF_ITEMKEY | VARCHAR2 | (240) | Workflow Item Key | |
OPERATION_YIELD | NUMBER | Operation yield for an operation | ||
OPERATION_YIELD_ENABLED | NUMBER | Indicates whether operation yield is to be considered by the cost processor | ||
PRE_SPLIT_QUANTITY | NUMBER | Start Quantity of Parent job in case of split transaction | ||
OPERATION_COMPLETED | VARCHAR2 | (1) | To indicated if the operation has been completed | |
SHUTDOWN_TYPE | VARCHAR2 | (30) | Shutdown Type | |
X_POS | NUMBER | X Coordinate position for the operation. | ||
Y_POS | NUMBER | Y Coordinate position for the operation. | ||
PREVIOUS_OPERATION_SEQ_ID | NUMBER | Previous operation sequence identification | ||
SKIP_FLAG | NUMBER | This flag used to determine whether material and resource should be charged or not | ||
LONG_DESCRIPTION | VARCHAR2 | (4000) | long description | |
DISABLE_DATE | DATE | Disable date | ||
CUMULATIVE_SCRAP_QUANTITY | NUMBER | Total number of assemblies scrapped in previous operations | ||
RECOMMENDED | VARCHAR2 | (1) | This column determine whether this operation is on recommended path or not | |
PROGRESS_PERCENTAGE | NUMBER | This column stores the progress percentage for the current operation | ||
WSM_OP_SEQ_NUM | NUMBER | This column stores operation sequence number used by OSFM team only. | ||
ACTUAL_START_DATE | DATE | An actual operation start date. | ||
ACTUAL_COMPLETION_DATE | DATE | An actual operation completion date. | ||
FORECAST_ID | NUMBER | Yes | Forecast Id | |
WSM_BONUS_QUANTITY | NUMBER | Bonus quantity | ||
EMPLOYEE_ID | NUMBER | Employee ID. | ||
PROJECT_COMPLETION_DATE | DATE | Projected completion date. | ||
WSM_UPDATE_QUANTITY_TXN_ID | NUMBER | An ID of WSM update quantity transaction. | ||
WSM_UPDATE_QUANTITY_COMPLETED | NUMBER | A quantity that has been costed. | ||
LOWEST_ACCEPTABLE_YIELD | NUMBER | A lowest acceptable yield. | ||
LOW_YIELD_TRIGGER_LIMIT | NUMBER | Not Used |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, ORGANIZATION_ID
, REPETITIVE_SCHEDULE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OPERATION_SEQUENCE_ID
, STANDARD_OPERATION_ID
, DEPARTMENT_ID
, DESCRIPTION
, SCHEDULED_QUANTITY
, QUANTITY_IN_QUEUE
, QUANTITY_RUNNING
, QUANTITY_WAITING_TO_MOVE
, QUANTITY_REJECTED
, QUANTITY_SCRAPPED
, QUANTITY_COMPLETED
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, PREVIOUS_OPERATION_SEQ_NUM
, NEXT_OPERATION_SEQ_NUM
, COUNT_POINT_TYPE
, BACKFLUSH_FLAG
, MINIMUM_TRANSFER_QUANTITY
, DATE_LAST_MOVED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, WF_ITEMTYPE
, WF_ITEMKEY
, OPERATION_YIELD
, OPERATION_YIELD_ENABLED
, PRE_SPLIT_QUANTITY
, OPERATION_COMPLETED
, SHUTDOWN_TYPE
, X_POS
, Y_POS
, PREVIOUS_OPERATION_SEQ_ID
, SKIP_FLAG
, LONG_DESCRIPTION
, DISABLE_DATE
, CUMULATIVE_SCRAP_QUANTITY
, RECOMMENDED
, PROGRESS_PERCENTAGE
, WSM_OP_SEQ_NUM
, ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE
, FORECAST_ID
, WSM_BONUS_QUANTITY
, EMPLOYEE_ID
, PROJECT_COMPLETION_DATE
, WSM_UPDATE_QUANTITY_TXN_ID
, WSM_UPDATE_QUANTITY_COMPLETED
, LOWEST_ACCEPTABLE_YIELD
, LOW_YIELD_TRIGGER_LIMIT
FROM EAM.EAM_FORECAST_WO;
EAM.EAM_FORECAST_WO does not reference any database object
EAM.EAM_FORECAST_WO is referenced by following:
|
|
|