APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_OPERATION_RESOURCES

Line 1966: from wip_operation_resources wor

1962: CURSOR l_op_resources is
1963: select
1964: wor.start_date as res_start_date,
1965: wor.completion_date as res_completion_date
1966: from wip_operation_resources wor
1967: where wor.wip_entity_id = p_wip_entity_id
1968: and wor.organization_id = p_organization_id;
1969:
1970: CURSOR l_op_records_cur is

Line 2145: wip_operation_resources wor

2141: wo.last_unit_completion_date as op_completion_date,
2142: wor.start_date as res_start_date,
2143: wor.completion_date as res_completion_date
2144: from wip_operations wo,
2145: wip_operation_resources wor
2146: where wo.wip_entity_id = p_wip_entity_id
2147: and wor.wip_entity_id = p_wip_entity_id
2148: and wo.operation_seq_num = wor.operation_seq_num;
2149:

Line 2169: wip_operation_resources wor

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
2173: and wori.resource_seq_num = wor.resource_seq_num;

Line 2204: wip_operation_resources wor,

2200: woru.completion_date as res_usg_completion_date,
2201: wor.start_date as res_start_date,
2202: wor.completion_date as res_completion_date
2203: from
2204: wip_operation_resources wor,
2205: wip_operation_resource_usage woru
2206: where
2207: wor.wip_entity_id = p_wip_entity_id
2208: and woru.wip_entity_id = p_wip_entity_id

Line 2348: wip_operation_resources wor

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
2352: and wori.operation_seq_num = wor.operation_seq_num

Line 2387: update wip_operation_resources wor

2383: LOOP FETCH l_resource_instances into l_resource_inst_record;
2384:
2385: IF l_resource_inst_record.resinst_start_date < l_resource_inst_record.res_start_date THEN
2386:
2387: update wip_operation_resources wor
2388: set start_date = l_resource_inst_record.res_start_date
2389: where wor.wip_entity_id = l_resource_inst_record.wip_entity_id
2390: and wor.operation_seq_num = l_resource_inst_record.operation_seq_num
2391: and wor.resource_seq_num = l_resource_inst_record.resource_seq_num ;

Line 2398: update wip_operation_resources wor

2394: END IF;
2395:
2396: IF l_resource_inst_record.resinst_completion_date > l_resource_inst_record.res_completion_date THEN
2397:
2398: update wip_operation_resources wor
2399: set completion_date = l_resource_inst_record.res_completion_date
2400: where wor.wip_entity_id = l_resource_inst_record.wip_entity_id
2401: and wor.operation_seq_num = l_resource_inst_record.operation_seq_num
2402: and wor.resource_seq_num = l_resource_inst_record.resource_seq_num;