APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1961: from wip_op_resource_instances wori

1957: CURSOR l_resource_instances is
1958: select
1959: wori.start_date as resinst_start_date,
1960: wori.completion_date as resinst_completion_date
1961: from wip_op_resource_instances wori
1962: where wori.wip_entity_id = p_wip_entity_id;
1963:
1964:
1965: TYPE l_sub_resource_records IS RECORD (

Line 2141: from wip_op_resource_instances wori,

2137: wor.start_date as res_start_date,
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

Line 2159: wip_op_resource_instances wori,

2155: wori.start_date as resinst_start_date,
2156: wori.completion_date as resinst_completion_date,
2157: wori.instance_id as resinst_instance_id
2158: from
2159: wip_op_resource_instances wori,
2160: wip_operation_resource_usage woru
2161: where
2162: woru.wip_entity_id = p_wip_entity_id
2163: and wori.wip_entity_id = p_wip_entity_id

Line 2320: wip_op_resource_instances wori,

2316: wori.start_date as resinst_start_date,
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

Line 2339: wip_op_resource_instances wori,

2335: wori.start_date as resinst_start_date,
2336: wori.completion_date as resinst_completion_date,
2337: wori.instance_id as resinst_instance_id
2338: from
2339: wip_op_resource_instances wori,
2340: wip_operation_resource_usage woru
2341: where
2342: woru.wip_entity_id = p_wip_entity_id
2343: and wori.wip_entity_id = p_wip_entity_id

Line 2388: update wip_op_resource_instances wori

2384: LOOP FETCH l_res_usage_instances into l_res_usage_inst_record;
2385:
2386: IF l_res_usage_inst_record.res_usg_start_date < l_res_usage_inst_record.resinst_start_date THEN
2387:
2388: update wip_op_resource_instances wori
2389: set start_date = l_res_usage_inst_record.res_usg_start_date
2390: where wori.wip_entity_id = l_res_usage_inst_record.wip_entity_id
2391: and wori.operation_seq_num = l_res_usage_inst_record.operation_seq_num
2392: and wori.resource_seq_num = l_res_usage_inst_record.resource_seq_num

Line 2400: update wip_op_resource_instances wori

2396: END IF;
2397:
2398: IF l_res_usage_inst_record.res_usg_completion_date > l_res_usage_inst_record.resinst_completion_date THEN
2399:
2400: update wip_op_resource_instances wori
2401: set completion_date = l_res_usage_inst_record.res_usg_completion_date
2402: where wori.wip_entity_id = l_res_usage_inst_record.wip_entity_id
2403: and wori.operation_seq_num = l_res_usage_inst_record.operation_seq_num
2404: and wori.resource_seq_num = l_res_usage_inst_record.resource_seq_num