VIEW: APPS.WIP_EAM_PRIOR_OPERATIONS_V

Source

View Text - Preformatted

SELECT won.wip_entity_id, won.organization_id, won.prior_operation, wo.description prior_op_desc, wo.first_unit_start_date prior_op_start_date, wo.last_unit_completion_date prior_op_completion_date, wo.department_id prior_op_dept_id, bd.department_code prior_op_dept_code, won.next_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.prior_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.PRIOR_OPERATION
, WO.DESCRIPTION PRIOR_OP_DESC
, WO.FIRST_UNIT_START_DATE PRIOR_OP_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE PRIOR_OP_COMPLETION_DATE
, WO.DEPARTMENT_ID PRIOR_OP_DEPT_ID
, BD.DEPARTMENT_CODE PRIOR_OP_DEPT_CODE
, WON.NEXT_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.PRIOR_OPERATION = WO.OPERATION_SEQ_NUM
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BD.ORGANIZATION_ID = WO.ORGANIZATION_ID