APPS.EAM_PROCESS_WO_PVT dependencies on WIP_OPERATIONS

Line 8498: from wip_operations

8494:
8495: Begin
8496: select 1
8497: into l_count
8498: from wip_operations
8499: where wip_entity_id = l_eam_wo_rec.wip_entity_id
8500: and department_id is null;
8501: Exception
8502: When no_data_found then

Line 9008: from wip_operations

9004:
9005: begin
9006: select operation_seq_num,first_unit_start_date
9007: bulk collect into l_wkorder_old_op_tbl,l_wkorder_old_op_dt_tbl
9008: from wip_operations
9009: where organization_id = l_organization_id
9010: and wip_entity_id = l_wip_entity_id ;
9011: exception when others then
9012: null;

Line 9500: from wip_operations

9496:
9497: begin
9498: select operation_seq_num,first_unit_start_date
9499: bulk collect into l_wkorder_new_op_tbl,l_wkorder_new_op_dt_tbl
9500: from wip_operations
9501: where organization_id = l_organization_id
9502: and wip_entity_id = l_wip_entity_id;
9503: exception when others then
9504: null;

Line 10823: FROM wip_operations

10819: (l_wip_entity_id NUMBER,l_org_id NUMBER,l_op_seq_num NUMBER)
10820: IS
10821: SELECT first_unit_start_date,
10822: last_unit_completion_date
10823: FROM wip_operations
10824: WHERE wip_entity_id=l_wip_entity_id
10825: AND organization_id=l_org_id
10826: AND operation_seq_num=l_op_seq_num;
10827:

Line 12630: FROM WIP_OPERATIONS

12626: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN
12627:
12628: SELECT last_unit_completion_date
12629: INTO l_op_sched_end_date
12630: FROM WIP_OPERATIONS
12631: WHERE wip_entity_id= l_eam_op_comp_rec.wip_entity_id
12632: AND operation_seq_num = l_eam_op_comp_rec.operation_seq_num;
12633:
12634: l_is_last_operation := 'N';