DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 10165: UPDATE wip_op_resource_instances

10161: IF l_woru_modified ='N' THEN
10162:
10163: FOR c_opresource_rec IN get_opresource_csr(l_eam_wo_rec.wip_entity_id) LOOP
10164:
10165: UPDATE wip_op_resource_instances
10166: SET start_date = c_opresource_rec.start_date,
10167: completion_date=c_opresource_rec.completion_date
10168: WHERE wip_entity_id = l_wip_entity_id
10169: AND operation_seq_num = c_opresource_rec.operation_seq_num

Line 11456: FROM wip_op_resource_instances

11452: (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)
11453: IS
11454: SELECT start_date,
11455: completion_date
11456: FROM wip_op_resource_instances
11457: WHERE wip_entity_id=l_wip_entity_id
11458: AND organization_id=l_org_id
11459: AND operation_seq_num=l_op_seq_num
11460: AND resource_seq_num=l_res_seq_num