[Home] [Help] [Dependency Information]
Object Name: | WIP_OPERATIONS_INQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_OPERATIONS_INQ_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
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 | ||
JOB_NAME | VARCHAR2 | (240) | WIP job name | |
JOB_DESCRIPTION | VARCHAR2 | (240) | Description of the discrete job | |
PRIMARY_ITEM_ID | NUMBER | Inventory item identifier of assembly the job or schedule creates | ||
STATUS_TYPE | NUMBER | Status of jobs or repetitive schedules | ||
STATUS_CODE | VARCHAR2 | (80) | Yes | Status code |
LINE_ID | NUMBER | WIP line identifier | ||
LINE_CODE | VARCHAR2 | (10) | Line name | |
START_DATE | DATE | Job/Schedule start date | ||
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 identifier | ||
STANDARD_OPERATION_ID | NUMBER | Standard operation identifier | ||
OPERATION_CODE | VARCHAR2 | (4) | Standard operation code | |
DEPARTMENT_ID | NUMBER | Yes | Department identifier | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Yes | Department code |
LOCATION_ID | NUMBER | Location identifier | ||
DESCRIPTION | VARCHAR2 | (240) | Descriptive text | |
SCHEDULED_QUANTITY | NUMBER | Yes | Number of units scheduled for the operation | |
QUANTITY_IN_QUEUE | VARCHAR2 | (40) | Number of units in queue of the operation | |
QUANTITY_RUNNING | VARCHAR2 | (40) | Number of units in run of the operation | |
QUANTITY_WAITING_TO_MOVE | VARCHAR2 | (40) | Number of units waiting to move in the operation | |
QUANTITY_REJECTED | VARCHAR2 | (40) | Number of units rejected from the operation | |
QUANTITY_SCRAPPED | VARCHAR2 | (40) | Number of units scrapped from the operation | |
QUANTITY_COMPLETED | VARCHAR2 | (40) | Number of units completed by the operation | |
QUANTITY_REMAINING | NUMBER | Quantity remaining for jobs or repetitive schedules | ||
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 | NUMBER | Count point control code | ||
AUTOCHARGE_FLAG | NUMBER | Resource charging control code | ||
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 flexfiled 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) | Descriptitve 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 | |
PREV_DEPARTMENT | VARCHAR2 | (10) | Department identifier of previous operation | |
PREV_LUCD | DATE | Last unit scheduled completion date of previous operation | ||
PREV_QUANTITY_IN_QUEUE | VARCHAR2 | (40) | Number of units in queue of the previous operation | |
PREV_QUANTITY_RUNNING | VARCHAR2 | (40) | Number of units in run of the previous operation | |
PREV_QUANTITY_COMPLETED | VARCHAR2 | (40) | Number of units completed by the previous operation | |
PREV_QUANTITY_TO_MOVE | VARCHAR2 | (40) | Number of units waiting to move in the previous operation | |
PROGRESS_PERCENTAGE | NUMBER | This column stores the progress percentage for this operation |
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
, JOB_NAME
, JOB_DESCRIPTION
, PRIMARY_ITEM_ID
, STATUS_TYPE
, STATUS_CODE
, LINE_ID
, LINE_CODE
, START_DATE
, 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
, QUANTITY_REMAINING
, 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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PREV_DEPARTMENT
, PREV_LUCD
, PREV_QUANTITY_IN_QUEUE
, PREV_QUANTITY_RUNNING
, PREV_QUANTITY_COMPLETED
, PREV_QUANTITY_TO_MOVE
, PROGRESS_PERCENTAGE
FROM APPS.WIP_OPERATIONS_INQ_V;
APPS.WIP_OPERATIONS_INQ_V is not referenced by any database object
|
|
|