DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 950: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1

946:
947: CURSOR l_op_network(l_wip_entity_id NUMBER) IS
948: SELECT
949: won.prior_operation,won.next_operation,wo.last_unit_completion_date,wo1.first_unit_start_date
950: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1
951: WHERE won.wip_entity_id = wo.wip_entity_id AND
952: won.wip_entity_id = wo1.wip_entity_id AND
953: won.prior_operation = wo.operation_seq_num AND
954: won.next_operation = wo1.operation_seq_num AND

Line 999: FROM wip_operations

995: --1.Is Op Completed
996:
997: SELECT nvl(operation_completed, 'N')
998: INTO l_op_completed
999: FROM wip_operations
1000: WHERE wip_entity_id = p_wip_entity_id
1001: AND operation_seq_num = p_op_seq_num;
1002:
1003: IF l_op_completed = 'Y' THEN