APPS.EAM_PROCESS_WO_PUB dependencies on WIP_OPERATIONS

Line 4720: from wip_operations

4716: attribute13 ,
4717: attribute14 ,
4718: attribute15 ,
4719: long_description
4720: from wip_operations
4721: where wip_entity_id = p_wip_entity_id;
4722:
4723: CURSOR l_op_resources is
4724: select

Line 4764: from wip_operations wo,

4760: wor.attribute13 ,
4761: wor.attribute14 ,
4762: wor.attribute15 ,
4763: wor.department_id
4764: from wip_operations wo,
4765: wip_operation_resources wor
4766: where wo.wip_entity_id = p_wip_entity_id
4767: and wor.wip_entity_id = p_wip_entity_id
4768: and wo.operation_seq_num = wor.operation_seq_num;

Line 5234: update wip_operations wo

5230: update wip_discrete_jobs
5231: set primary_item_id = l_old_activity_id
5232: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;
5233:
5234: update wip_operations wo
5235: set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1
5236: where wo.OPERATION_SEQ_NUM = wo1.OPERATION_SEQ_NUM
5237: and wo1.wip_entity_id = p_wip_entity_id
5238: )

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

5231: set primary_item_id = l_old_activity_id
5232: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;
5233:
5234: update wip_operations wo
5235: set STANDARD_OPERATION_ID = ( select STANDARD_OPERATION_ID from wip_operations wo1
5236: where wo.OPERATION_SEQ_NUM = wo1.OPERATION_SEQ_NUM
5237: and wo1.wip_entity_id = p_wip_entity_id
5238: )
5239: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;