APPS.EAM_PROCESS_WO_PVT dependencies on WIP_OPERATIONS

Line 8527: from wip_operations wo,

8523: wor.ATTRIBUTE15,
8524: wo.DEPARTMENT_ID,
8525: decode(wor.SCHEDULED_FLAG,2,null,wor.resource_seq_num) ,
8526: wor.SUBSTITUTE_GROUP_NUM
8527: from wip_operations wo,
8528: wip_OPERATION_resources wor,
8529: bom_resources br
8530: where wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
8531: and br.resource_id = wor.resource_id

Line 9048: from wip_operations

9044:
9045: Begin
9046: select 1
9047: into l_count
9048: from wip_operations
9049: where wip_entity_id = l_eam_wo_rec.wip_entity_id
9050: and department_id is null;
9051: Exception
9052: When no_data_found then

Line 9568: from wip_operations

9564:
9565: begin
9566: select operation_seq_num,first_unit_start_date
9567: bulk collect into l_wkorder_old_op_tbl,l_wkorder_old_op_dt_tbl
9568: from wip_operations
9569: where organization_id = l_organization_id
9570: and wip_entity_id = l_wip_entity_id ;
9571: exception when others then
9572: null;

Line 10106: from wip_operations

10102:
10103: begin
10104: select operation_seq_num,first_unit_start_date
10105: bulk collect into l_wkorder_new_op_tbl,l_wkorder_new_op_dt_tbl
10106: from wip_operations
10107: where organization_id = l_organization_id
10108: and wip_entity_id = l_wip_entity_id;
10109: exception when others then
10110: null;

Line 11431: FROM wip_operations

11427: (l_wip_entity_id NUMBER,l_org_id NUMBER,l_op_seq_num NUMBER)
11428: IS
11429: SELECT first_unit_start_date,
11430: last_unit_completion_date
11431: FROM wip_operations
11432: WHERE wip_entity_id=l_wip_entity_id
11433: AND organization_id=l_org_id
11434: AND operation_seq_num=l_op_seq_num;
11435:

Line 13300: FROM WIP_OPERATIONS

13296: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN
13297:
13298: SELECT last_unit_completion_date
13299: INTO l_op_sched_end_date
13300: FROM WIP_OPERATIONS
13301: WHERE wip_entity_id= l_eam_op_comp_rec.wip_entity_id
13302: AND operation_seq_num = l_eam_op_comp_rec.operation_seq_num;
13303:
13304: l_is_last_operation := 'N';