VIEW: APPS.WIP_EAM_NEXT_OPERATIONS_V

Source

View Text - Preformatted

SELECT won.wip_entity_id, won.organization_id, won.next_operation, wo.description next_op_desc, wo.first_unit_start_date next_op_start_date, wo.last_unit_completion_date next_op_completion_date, wo.department_id next_op_department_id, bd.department_code next_op_dept_code, won.prior_operation, nvl(wo.operation_completed,'N') op_completed from wip_operation_networks won, wip_operations wo, bom_departments bd where won.wip_entity_id = wo.wip_entity_id and won.organization_id = wo.organization_id and won.next_operation = wo.operation_seq_num and bd.department_id = wo.department_id and bd.organization_id = wo.organization_id

View Text - HTML Formatted

SELECT WON.WIP_ENTITY_ID
, WON.ORGANIZATION_ID
, WON.NEXT_OPERATION
, WO.DESCRIPTION NEXT_OP_DESC
, WO.FIRST_UNIT_START_DATE NEXT_OP_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE NEXT_OP_COMPLETION_DATE
, WO.DEPARTMENT_ID NEXT_OP_DEPARTMENT_ID
, BD.DEPARTMENT_CODE NEXT_OP_DEPT_CODE
, WON.PRIOR_OPERATION
, NVL(WO.OPERATION_COMPLETED
, 'N') OP_COMPLETED
FROM WIP_OPERATION_NETWORKS WON
, WIP_OPERATIONS WO
, BOM_DEPARTMENTS BD
WHERE WON.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WON.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND WON.NEXT_OPERATION = WO.OPERATION_SEQ_NUM
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BD.ORGANIZATION_ID = WO.ORGANIZATION_ID