[Home] [Help] [Dependency Information]
Object Name: | PJM_PROJECT_WIP_OP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJM.PJM_PROJECT_WIP_OP_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
PJM_PROJECT_WIP_OP_V returns operations information for each WIP job.
This view corresponds to the Operations web inquiry region.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ROWIDor row identifier for WIP_OPERATIONS | |
WIP_ENTITY_ID | NUMBER | Yes | WIP job unique identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number within a routing | |
ORGANIZATION_ID | NUMBER | Yes | Organization unique 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 | Extended Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Extended Who column | ||
PROGRAM_ID | NUMBER | Extended Who column | ||
PROGRAM_UPDATE_DATE | DATE | Extended Who column | ||
OPERATION_SEQUENCE_ID | NUMBER | Operation sequence unique identifier | ||
STANDARD_OPERATION_ID | NUMBER | Standard operation unique identifier | ||
OPERATION_CODE | VARCHAR2 | (4) | Standard operation code | |
DEPARTMENT_ID | NUMBER | Yes | Department unique identifier | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Yes | Department name |
LOCATION_ID | NUMBER | Location unique identifier | ||
DESCRIPTION | VARCHAR2 | (240) | Descriptive text | |
SCHEDULED_QUANTITY | NUMBER | Yes | Number of units scheduled for the operation | |
QUANTITY_IN_QUEUE | NUMBER | Number of units in queue of the operation | ||
QUANTITY_RUNNING | NUMBER | Number of units in run of the operation | ||
QUANTITY_WAITING_TO_MOVE | NUMBER | Number of units waiting to move in the operation | ||
QUANTITY_REJECTED | NUMBER | Number of units rejected from the operation | ||
QUANTITY_SCRAPPED | NUMBER | Number of units scrapped from the operation | ||
QUANTITY_COMPLETED | NUMBER | 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 | |
COUNT_POINT_FLAG | VARCHAR2 | (4000) | Count point control code | |
AUTOCHARGE_FLAG | VARCHAR2 | (4000) | Resource charging control code | |
BACKFLUSH_FLAG | VARCHAR2 | (4000) | Backflush control code | |
MINIMUM_TRANSFER_QUANTITY | NUMBER | Yes | Minimum operation transfer quantity | |
DATE_LAST_MOVED | DATE | Operation last move date |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, OPERATION_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, LOCATION_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
, COUNT_POINT_FLAG
, AUTOCHARGE_FLAG
, BACKFLUSH_FLAG
, MINIMUM_TRANSFER_QUANTITY
, DATE_LAST_MOVED
FROM APPS.PJM_PROJECT_WIP_OP_V;
APPS.PJM_PROJECT_WIP_OP_V is not referenced by any database object
|
|
|