124: FROM wip_discrete_jobs wdj,
125: wip_operations wo1,
126: wip_operations wo2,
127: mtl_system_items_kfv msik,
128: bom_standard_operations bso1,
129: bom_standard_operations bso2,
130: bom_departments bd1,
131: bom_departments bd2
132: WHERE wo1.wip_entity_id = wdj.wip_entity_id
125: wip_operations wo1,
126: wip_operations wo2,
127: mtl_system_items_kfv msik,
128: bom_standard_operations bso1,
129: bom_standard_operations bso2,
130: bom_departments bd1,
131: bom_departments bd2
132: WHERE wo1.wip_entity_id = wdj.wip_entity_id
133: AND wo1.organization_id = wdj.organization_id
236:
237: BEGIN
238: select bso.operation_code
239: into l_operation_code
240: from wip_operations wo, bom_standard_operations bso
241: where wo.wip_entity_id = p_wip_entity_id
242: and wo.organization_id = p_org_id
243: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
244: and wo.standard_operation_id = bso.standard_operation_id(+);
409: FROM wip_discrete_jobs wdj,
410: wip_operations wo1,
411: wip_operations wo2,
412: mtl_system_items_kfv msik,
413: bom_standard_operations bso1,
414: bom_standard_operations bso2,
415: bom_departments bd1,
416: bom_departments bd2
417: WHERE wo1.wip_entity_id = wdj.wip_entity_id
410: wip_operations wo1,
411: wip_operations wo2,
412: mtl_system_items_kfv msik,
413: bom_standard_operations bso1,
414: bom_standard_operations bso2,
415: bom_departments bd1,
416: bom_departments bd2
417: WHERE wo1.wip_entity_id = wdj.wip_entity_id
418: AND wo1.organization_id = wdj.organization_id