Product: | PJM - Project Manufacturing |
---|---|
Description: | WIP job operation information for the Web Inquiry. |
Implementation/DBA Data: | APPS.PJM_PROJECT_WIP_OP_V |
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
, TO_NUMBER(QUANTITY_IN_QUEUE)
, TO_NUMBER(QUANTITY_RUNNING)
, TO_NUMBER(QUANTITY_WAITING_TO_MOVE)
, TO_NUMBER(QUANTITY_REJECTED)
, TO_NUMBER(QUANTITY_SCRAPPED)
, TO_NUMBER(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
, PJM_INQUIRY.SYS_YES_NO( COUNT_POINT_FLAG )
, PJM_INQUIRY.SYS_YES_NO( AUTOCHARGE_FLAG )
, PJM_INQUIRY.SYS_YES_NO( BACKFLUSH_FLAG )
, MINIMUM_TRANSFER_QUANTITY
, DATE_LAST_MOVED
FROM WIP_OPERATIONS_V