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 304: bom_departments bd1,

300: wip_operations wo2,
301: mtl_system_items_kfv msik,
302: bom_standard_operations bso1,
303: bom_standard_operations bso2,
304: bom_departments bd1,
305: bom_departments bd2
306: WHERE wo1.wip_entity_id = wdj.wip_entity_id
307: AND wo1.organization_id = wdj.organization_id
308: AND wo1.operation_seq_num = p_fm_op_seq

Line 305: bom_departments bd2

301: mtl_system_items_kfv msik,
302: bom_standard_operations bso1,
303: bom_standard_operations bso2,
304: bom_departments bd1,
305: bom_departments bd2
306: WHERE wo1.wip_entity_id = wdj.wip_entity_id
307: AND wo1.organization_id = wdj.organization_id
308: AND wo1.operation_seq_num = p_fm_op_seq
309: AND wo1.standard_operation_id = bso1.standard_operation_id(+)