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
2164: and wori.operation_seq_num = woru.operation_seq_num
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
2182: and wor.resource_seq_num = woru.resource_seq_num
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
2344: and wori.operation_seq_num = woru.operation_seq_num