VIEW: APPS.PJM_PROJECT_WIP_OP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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