APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1988: from wip_op_resource_instances wori

1984: CURSOR l_resource_instances is
1985: select
1986: wori.start_date as resinst_start_date,
1987: wori.completion_date as resinst_completion_date
1988: from wip_op_resource_instances wori
1989: where wori.wip_entity_id = p_wip_entity_id;
1990:
1991:
1992: TYPE l_sub_resource_records IS RECORD (

Line 2168: from wip_op_resource_instances wori,

2164: wor.start_date as res_start_date,
2165: wor.completion_date as res_completion_date,
2166: wori.start_date as resinst_start_date,
2167: wori.completion_date as resinst_completion_date
2168: from wip_op_resource_instances wori,
2169: wip_operation_resources wor
2170: where wor.wip_entity_id = p_wip_entity_id
2171: and wori.wip_entity_id = p_wip_entity_id
2172: and wori.operation_seq_num = wor.operation_seq_num

Line 2186: wip_op_resource_instances wori,

2182: wori.start_date as resinst_start_date,
2183: wori.completion_date as resinst_completion_date,
2184: wori.instance_id as resinst_instance_id
2185: from
2186: wip_op_resource_instances wori,
2187: wip_operation_resource_usage woru
2188: where
2189: woru.wip_entity_id = p_wip_entity_id
2190: and wori.wip_entity_id = p_wip_entity_id

Line 2347: wip_op_resource_instances wori,

2343: wori.start_date as resinst_start_date,
2344: wori.completion_date as resinst_completion_date,
2345: wori.instance_id as resinst_instance_id
2346: from
2347: wip_op_resource_instances wori,
2348: wip_operation_resources wor
2349: where
2350: wor.wip_entity_id = p_wip_entity_id
2351: and wori.wip_entity_id = p_wip_entity_id

Line 2366: wip_op_resource_instances wori,

2362: wori.start_date as resinst_start_date,
2363: wori.completion_date as resinst_completion_date,
2364: wori.instance_id as resinst_instance_id
2365: from
2366: wip_op_resource_instances wori,
2367: wip_operation_resource_usage woru
2368: where
2369: woru.wip_entity_id = p_wip_entity_id
2370: and wori.wip_entity_id = p_wip_entity_id

Line 2415: update wip_op_resource_instances wori

2411: LOOP FETCH l_res_usage_instances into l_res_usage_inst_record;
2412:
2413: IF l_res_usage_inst_record.res_usg_start_date < l_res_usage_inst_record.resinst_start_date THEN
2414:
2415: update wip_op_resource_instances wori
2416: set start_date = l_res_usage_inst_record.res_usg_start_date
2417: where wori.wip_entity_id = l_res_usage_inst_record.wip_entity_id
2418: and wori.operation_seq_num = l_res_usage_inst_record.operation_seq_num
2419: and wori.resource_seq_num = l_res_usage_inst_record.resource_seq_num

Line 2427: update wip_op_resource_instances wori

2423: END IF;
2424:
2425: IF l_res_usage_inst_record.res_usg_completion_date > l_res_usage_inst_record.resinst_completion_date THEN
2426:
2427: update wip_op_resource_instances wori
2428: set completion_date = l_res_usage_inst_record.res_usg_completion_date
2429: where wori.wip_entity_id = l_res_usage_inst_record.wip_entity_id
2430: and wori.operation_seq_num = l_res_usage_inst_record.operation_seq_num
2431: and wori.resource_seq_num = l_res_usage_inst_record.resource_seq_num