APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OPERATION_RESOURCES

Line 1939: from wip_operation_resources wor

1935: CURSOR l_op_resources is
1936: select
1937: wor.start_date as res_start_date,
1938: wor.completion_date as res_completion_date
1939: from wip_operation_resources wor
1940: where wor.wip_entity_id = p_wip_entity_id
1941: and wor.organization_id = p_organization_id;
1942:
1943: CURSOR l_op_records_cur is

Line 2118: wip_operation_resources wor

2114: wo.last_unit_completion_date as op_completion_date,
2115: wor.start_date as res_start_date,
2116: wor.completion_date as res_completion_date
2117: from wip_operations wo,
2118: wip_operation_resources wor
2119: where wo.wip_entity_id = p_wip_entity_id
2120: and wor.wip_entity_id = p_wip_entity_id
2121: and wo.operation_seq_num = wor.operation_seq_num;
2122:

Line 2142: wip_operation_resources wor

2138: wor.completion_date as res_completion_date,
2139: wori.start_date as resinst_start_date,
2140: wori.completion_date as resinst_completion_date
2141: from wip_op_resource_instances wori,
2142: wip_operation_resources wor
2143: where wor.wip_entity_id = p_wip_entity_id
2144: and wori.wip_entity_id = p_wip_entity_id
2145: and wori.operation_seq_num = wor.operation_seq_num
2146: and wori.resource_seq_num = wor.resource_seq_num;

Line 2177: wip_operation_resources wor,

2173: woru.completion_date as res_usg_completion_date,
2174: wor.start_date as res_start_date,
2175: wor.completion_date as res_completion_date
2176: from
2177: wip_operation_resources wor,
2178: wip_operation_resource_usage woru
2179: where
2180: wor.wip_entity_id = p_wip_entity_id
2181: and woru.wip_entity_id = p_wip_entity_id

Line 2321: wip_operation_resources wor

2317: wori.completion_date as resinst_completion_date,
2318: wori.instance_id as resinst_instance_id
2319: from
2320: wip_op_resource_instances wori,
2321: wip_operation_resources wor
2322: where
2323: wor.wip_entity_id = p_wip_entity_id
2324: and wori.wip_entity_id = p_wip_entity_id
2325: and wori.operation_seq_num = wor.operation_seq_num

Line 2360: update wip_operation_resources wor

2356: LOOP FETCH l_resource_instances into l_resource_inst_record;
2357:
2358: IF l_resource_inst_record.resinst_start_date < l_resource_inst_record.res_start_date THEN
2359:
2360: update wip_operation_resources wor
2361: set start_date = l_resource_inst_record.res_start_date
2362: where wor.wip_entity_id = l_resource_inst_record.wip_entity_id
2363: and wor.operation_seq_num = l_resource_inst_record.operation_seq_num
2364: and wor.resource_seq_num = l_resource_inst_record.resource_seq_num ;

Line 2371: update wip_operation_resources wor

2367: END IF;
2368:
2369: IF l_resource_inst_record.resinst_completion_date > l_resource_inst_record.res_completion_date THEN
2370:
2371: update wip_operation_resources wor
2372: set completion_date = l_resource_inst_record.res_completion_date
2373: where wor.wip_entity_id = l_resource_inst_record.wip_entity_id
2374: and wor.operation_seq_num = l_resource_inst_record.operation_seq_num
2375: and wor.resource_seq_num = l_resource_inst_record.resource_seq_num;