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
134: AND wo1.operation_seq_num = p_fm_op_seq
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
134: AND wo1.operation_seq_num = p_fm_op_seq
135: AND wo1.standard_operation_id = bso1.standard_operation_id(+)
226: IF(l_custom_returnStatus = 'S' and l_hook_to_op_seq is not null and l_hook_to_step_type is not null) THEN
227: --Case 1: Success and to_op_seq/step. Carry out the transaction with value provided by the hook.
228: select wo.department_id, bd.department_code
229: into l_department_id, l_department_code
230: from wip_operations wo, bom_departments bd
231: where wo.wip_entity_id = p_wip_entity_id
232: and wo.organization_id = p_org_id
233: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
234: and wo.department_id = bd.department_id;
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
419: AND wo1.operation_seq_num = p_fm_op_seq
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
419: AND wo1.operation_seq_num = p_fm_op_seq
420: AND wo1.standard_operation_id = bso1.standard_operation_id(+)