DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on STANDARD

Line 128: bom_standard_operations bso1,

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

Line 129: bom_standard_operations bso2,

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

Line 135: AND wo1.standard_operation_id = bso1.standard_operation_id(+)

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(+)
136: AND wo1.department_id = bd1.department_id
137: AND wo2.wip_entity_id = wdj.wip_entity_id
138: AND wo2.organization_id = wdj.organization_id
139: AND wo2.operation_seq_num =

Line 149: AND wo2.standard_operation_id = bso2.standard_operation_id(+)

145: wo3.operation_seq_num > wo1.operation_seq_num) OR
146: (wo1.next_operation_seq_num IS NULL AND
147: wo3.operation_seq_num >= wo1.operation_seq_num))
148: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
149: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
150: AND wo2.department_id = bd2.department_id
151: AND wdj.primary_item_id = msik.inventory_item_id
152: AND wdj.organization_id = msik.organization_id
153: AND wdj.wip_entity_id = p_wip_entity_id

Line 302: bom_standard_operations bso1,

298: FROM wip_discrete_jobs wdj,
299: wip_operations wo1,
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

Line 303: bom_standard_operations bso2,

299: wip_operations wo1,
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

Line 309: AND wo1.standard_operation_id = bso1.standard_operation_id(+)

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(+)
310: AND wo1.department_id = bd1.department_id
311: AND wo2.wip_entity_id = wdj.wip_entity_id
312: AND wo2.organization_id = wdj.organization_id
313: AND wo2.operation_seq_num =

Line 323: AND wo2.standard_operation_id = bso2.standard_operation_id(+)

319: wo3.operation_seq_num > wo1.operation_seq_num) OR
320: (wo1.next_operation_seq_num IS NULL AND
321: wo3.operation_seq_num >= wo1.operation_seq_num))
322: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
323: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
324: AND wo2.department_id = bd2.department_id
325: AND wdj.primary_item_id = msik.inventory_item_id
326: AND wdj.organization_id = msik.organization_id
327: AND wdj.wip_entity_id = p_wip_entity_id