[Home] [Help]
89: and wjdi.wip_entity_id = we.wip_entity_id
90: and wjdi.inventory_item_id_old = msik.inventory_item_id
91: and wjdi.organization_id = msik.organization_id
92: and not exists (select 1
93: from wip_requirement_operations wro
94: where wro.wip_entity_id = wjdi.wip_entity_id
95: and wro.organization_id = wjdi.organization_id
96: and wro.operation_seq_num = wjdi.operation_seq_num
97: and wro.inventory_item_id = wjdi.inventory_item_id_old);
133: and wjdi.substitution_type = p_substitution_type
134: and wjdi.operation_seq_num = p_operation_seq_num
135: and wjdi.inventory_item_id_old = p_inventory_item_id_old
136: and not exists (select 1
137: from wip_requirement_operations wro
138: where wro.wip_entity_id = wjdi.wip_entity_id
139: and wro.organization_id = wjdi.organization_id
140: and wro.operation_seq_num = wjdi.operation_seq_num
141: and wro.inventory_item_id = wjdi.inventory_item_id_old);
166: and wjdi.substitution_type = p_substitution_type
167: and wjdi.operation_seq_num = p_operation_seq_num
168: and wjdi.inventory_item_id_old = p_inventory_item_id_old
169: and exists (select 1
170: from wip_requirement_operations wro
171: where wro.wip_entity_id = wjdi.wip_entity_id
172: and wro.organization_id = wjdi.organization_id
173: and wro.operation_seq_num = wjdi.operation_seq_num
174: and wro.inventory_item_id = wjdi.inventory_item_id_old
247: and wjdi.substitution_type = p_substitution_type
248: and wjdi.operation_seq_num = p_operation_seq_num
249: and wjdi.inventory_item_id_old = p_inventory_item_id_old
250: and exists (select 1
251: from wip_requirement_operations wro
252: where wro.wip_entity_id = wjdi.wip_entity_id
253: and wro.organization_id = wjdi.organization_id
254: and wro.operation_seq_num = wjdi.operation_seq_num
255: and wro.inventory_item_id = wjdi.inventory_item_id_old
490: and wjdi.inventory_item_id_new = p_inventory_item_id_new
491: /* bug#2814045 */
492: and nvl(wjdi.inventory_item_id_new, -1) <> nvl(wjdi.inventory_item_id_old, -1)
493: and ( exists (select 1
494: from wip_requirement_operations wro
495: where wro.wip_entity_id = wjdi.wip_entity_id
496: and wro.organization_id = wjdi.organization_id
497: and wro.operation_seq_num = wjdi.operation_seq_num
498: and wro.inventory_item_id = wjdi.inventory_item_id_new)
540: /* Fix for Bug 5632150 */
541: /* and wjdi.inventory_item_id_new <> wjdi.inventory_item_id_old */
542: and nvl(wjdi.inventory_item_id_new,-1) <> nvl(wjdi.inventory_item_id_old,-1)
543: and ( exists (select 1
544: from wip_requirement_operations wro
545: where wro.wip_entity_id = wjdi.wip_entity_id
546: and wro.organization_id = wjdi.organization_id
547: and wro.operation_seq_num = wjdi.operation_seq_num
548: and wro.inventory_item_id = wjdi.inventory_item_id_new)
1066: from bom_substitute_components bsc
1067: where bsc.substitute_component_id = wjdi.inventory_item_id_new
1068: and bsc.component_sequence_id =
1069: (select wro.component_sequence_id
1070: from wip_requirement_operations wro
1071: where wro.inventory_item_id = wjdi.inventory_item_id_old
1072: and wro.wip_entity_id = wjdi.wip_entity_id
1073: and wro.operation_seq_num = wjdi.operation_seq_num
1074: and wro.organization_id = wjdi.organization_id
1166: /*Component Yield Enhancement(Bug 4369064)->Get the current values of qpa, req_qty and yield*/
1167: begin
1168: SELECT nvl(component_yield_factor,1),required_quantity,quantity_per_assembly
1169: INTO x_component_yield_factor_wro,x_required_quantity_wro,x_quantity_per_assembly_wro
1170: FROM wip_requirement_operations
1171: WHERE wip_entity_id = p_wip_entity_id
1172: AND organization_id = p_organization_id
1173: AND inventory_item_id = p_inventory_item_id_old;
1174: exception