DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on BOM_DEPARTMENTS

Line 130: bom_departments bd1,

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

Line 131: bom_departments bd2

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(+)

Line 230: from wip_operations wo, bom_departments bd

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;

Line 415: bom_departments bd1,

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

Line 416: bom_departments bd2

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(+)