VIEW: APPS.WIPBV_WIP_OPERATIONS

Source

View Text - Preformatted

SELECT OP.OPERATION_SEQ_NUM , OP.DESCRIPTION , OP.QUANTITY_IN_QUEUE , OP.QUANTITY_RUNNING , OP.QUANTITY_WAITING_TO_MOVE , OP.QUANTITY_REJECTED , OP.QUANTITY_SCRAPPED , OP.QUANTITY_COMPLETED , OP.FIRST_UNIT_START_DATE , OP.FIRST_UNIT_COMPLETION_DATE , OP.LAST_UNIT_START_DATE , OP.LAST_UNIT_COMPLETION_DATE , '_LA:op.count_point_type:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING' , '_LA:op.backflush_flag:MFG_LOOKUPS:SYS_YES_NO:MEANING' , OP.MINIMUM_TRANSFER_QUANTITY , OP.DATE_LAST_MOVED , EN.WIP_ENTITY_NAME , OP.WIP_ENTITY_ID , OP.REPETITIVE_SCHEDULE_ID , OP.ORGANIZATION_ID , OP.OPERATION_SEQUENCE_ID , OP.STANDARD_OPERATION_ID , OP.DEPARTMENT_ID , OP.CREATION_DATE , OP.CREATED_BY , OP.LAST_UPDATE_DATE , OP.LAST_UPDATED_BY FROM WIP_ENTITIES EN , WIP_DISCRETE_JOBS DI , WIP_REPETITIVE_SCHEDULES RE , WIP_OPERATIONS OP WHERE NVL(OP.REPETITIVE_SCHEDULE_ID, -1) = NVL(RE.REPETITIVE_SCHEDULE_ID, -1) AND OP.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND OP.REPETITIVE_SCHEDULE_ID = RE.REPETITIVE_SCHEDULE_ID(+) AND OP.ORGANIZATION_ID = RE.ORGANIZATION_ID(+) AND OP.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+) AND OP.ORGANIZATION_ID = DI.ORGANIZATION_ID(+) AND '_SEC:op.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT OP.OPERATION_SEQ_NUM
, OP.DESCRIPTION
, OP.QUANTITY_IN_QUEUE
, OP.QUANTITY_RUNNING
, OP.QUANTITY_WAITING_TO_MOVE
, OP.QUANTITY_REJECTED
, OP.QUANTITY_SCRAPPED
, OP.QUANTITY_COMPLETED
, OP.FIRST_UNIT_START_DATE
, OP.FIRST_UNIT_COMPLETION_DATE
, OP.LAST_UNIT_START_DATE
, OP.LAST_UNIT_COMPLETION_DATE
, '_LA:OP.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:OP.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.MINIMUM_TRANSFER_QUANTITY
, OP.DATE_LAST_MOVED
, EN.WIP_ENTITY_NAME
, OP.WIP_ENTITY_ID
, OP.REPETITIVE_SCHEDULE_ID
, OP.ORGANIZATION_ID
, OP.OPERATION_SEQUENCE_ID
, OP.STANDARD_OPERATION_ID
, OP.DEPARTMENT_ID
, OP.CREATION_DATE
, OP.CREATED_BY
, OP.LAST_UPDATE_DATE
, OP.LAST_UPDATED_BY
FROM WIP_ENTITIES EN
, WIP_DISCRETE_JOBS DI
, WIP_REPETITIVE_SCHEDULES RE
, WIP_OPERATIONS OP
WHERE NVL(OP.REPETITIVE_SCHEDULE_ID
, -1) = NVL(RE.REPETITIVE_SCHEDULE_ID
, -1)
AND OP.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND OP.REPETITIVE_SCHEDULE_ID = RE.REPETITIVE_SCHEDULE_ID(+)
AND OP.ORGANIZATION_ID = RE.ORGANIZATION_ID(+)
AND OP.WIP_ENTITY_ID = DI.WIP_ENTITY_ID(+)
AND OP.ORGANIZATION_ID = DI.ORGANIZATION_ID(+)
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY