DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 9559: UPDATE wip_op_resource_instances

9555: IF l_woru_modified ='N' THEN
9556:
9557: FOR c_opresource_rec IN get_opresource_csr(l_eam_wo_rec.wip_entity_id) LOOP
9558:
9559: UPDATE wip_op_resource_instances
9560: SET start_date = c_opresource_rec.start_date,
9561: completion_date=c_opresource_rec.completion_date
9562: WHERE wip_entity_id = l_wip_entity_id
9563: AND operation_seq_num = c_opresource_rec.operation_seq_num

Line 10848: FROM wip_op_resource_instances

10844: (l_wip_entity_id NUMBER,l_org_id NUMBER,l_op_seq_num NUMBER,l_res_seq_num NUMBER,l_instance_id NUMBER,l_serial_number NUMBER)
10845: IS
10846: SELECT start_date,
10847: completion_date
10848: FROM wip_op_resource_instances
10849: WHERE wip_entity_id=l_wip_entity_id
10850: AND organization_id=l_org_id
10851: AND operation_seq_num=l_op_seq_num
10852: AND resource_seq_num=l_res_seq_num