APPS.EAM_PROCESS_WO_PUB dependencies on WIP_OPERATIONS

Line 5428: from wip_operations

5424: attribute13 ,
5425: attribute14 ,
5426: attribute15 ,
5427: long_description
5428: from wip_operations
5429: where wip_entity_id = p_wip_entity_id;
5430:
5431: CURSOR l_op_resources is
5432: select

Line 5472: from wip_operations wo,

5468: wor.attribute13 ,
5469: wor.attribute14 ,
5470: wor.attribute15 ,
5471: wor.department_id
5472: from wip_operations wo,
5473: wip_operation_resources wor
5474: where wo.wip_entity_id = p_wip_entity_id
5475: and wor.wip_entity_id = p_wip_entity_id
5476: and wo.operation_seq_num = wor.operation_seq_num;

Line 5946: update wip_operations wo

5942: update wip_entities
5943: set primary_item_id = l_old_activity_id
5944: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id; /*added for bug 9974953*/
5945:
5946: update wip_operations wo
5947: set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1
5948: where wo.OPERATION_SEQ_NUM = wo1.OPERATION_SEQ_NUM
5949: and wo1.wip_entity_id = p_wip_entity_id
5950: )

Line 5947: set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1

5943: set primary_item_id = l_old_activity_id
5944: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id; /*added for bug 9974953*/
5945:
5946: update wip_operations wo
5947: set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1
5948: where wo.OPERATION_SEQ_NUM = wo1.OPERATION_SEQ_NUM
5949: and wo1.wip_entity_id = p_wip_entity_id
5950: )
5951: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;

Line 6340: FROM wip_operations

6336: p_wip_entity_id is not null AND
6337: p_organization_id is not null)
6338: THEN
6339: SELECT department_id INTO l_department_id
6340: FROM wip_operations
6341: WHERE wip_entity_id = p_wip_entity_id AND
6342: operation_seq_num = p_operation_seq_num AND
6343: organization_id = p_organization_id;
6344: END IF;