[Home] [Help]
175: and organization_id = p_organization_id
176: and substitution_type = wip_job_details.wip_add
177: and ((load_type = wip_job_details.wip_res_instance_usage
178: and not exists (select 1
179: from wip_op_resource_instances
180: where wip_entity_id = wjdi.wip_entity_id
181: and organization_id = wjdi.organization_id
182: and operation_seq_num = wjdi.operation_seq_num
183: and resource_seq_num = wjdi.resource_seq_num
217: and organization_id = p_organization_id
218: and substitution_type = wip_job_details.wip_add
219: and ((load_type = wip_job_details.wip_res_instance_usage
220: and not exists (select 1
221: from wip_op_resource_instances
222: where wip_entity_id = wjdi.wip_entity_id
223: and organization_id = wjdi.organization_id
224: and operation_seq_num = wjdi.operation_seq_num
225: and resource_seq_num = wjdi.resource_seq_num
254: -- 1.Start date of usage is greater than or equal to start date of the corresponding resource or instance.
255: -- 2.Start and end dates of usage is in between start and end dates of corresponding resource or instance.
256: or start_date > completion_date
257: or exists (select 1
258: from wip_operation_resources wor,wip_op_resource_instances wori
259: where wor.wip_entity_id = p_wip_entity_id
260: and wor.operation_seq_num = wjdi.operation_seq_num
261: and wor.resource_seq_num = wjdi.resource_seq_num
262: and wor.wip_entity_id = wori.wip_entity_id(+)
303: -- 1.Start date of usage is greater than or equal to start date of the corresponding resource or instance.
304: -- 2.Start and end dates of usage is in between start and end dates of corresponding resource or instance.
305: or start_date > completion_date
306: or exists (select 1
307: from wip_operation_resources wor,wip_op_resource_instances wori
308: where wor.wip_entity_id = p_wip_entity_id
309: and wor.operation_seq_num = wjdi.operation_seq_num
310: and wor.resource_seq_num = wjdi.resource_seq_num
311: and wor.wip_entity_id = wori.wip_entity_id(+)