[Home] [Help]
[Dependency Information]
[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_INQUIRY
- show dependent code
WIP_OPERATIONS_V
APPS.PJM_PROJECT_WIP_OP_V is not referenced by any database object
|
|
|
|