eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 240: from wip_operations wo, bom_standard_operations bso

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

Line 244: and wo.standard_operation_id = bso.standard_operation_id(+);

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(+);
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: wip_logger.log('not a standard operation. operation_seq: ' || l_hook_to_op_seq, l_return_status);
248: END;

Line 247: wip_logger.log('not a standard operation. operation_seq: ' || l_hook_to_op_seq, l_return_status);

243: and wo.OPERATION_SEQ_NUM = l_hook_to_op_seq
244: and wo.standard_operation_id = bso.standard_operation_id(+);
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: wip_logger.log('not a standard operation. operation_seq: ' || l_hook_to_op_seq, l_return_status);
248: END;
249:
250: /*Using Hook's returned values*/
251: l_move_record.to_operation_seq_num := l_hook_to_op_seq;

Line 413: bom_standard_operations bso1,

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

Line 414: bom_standard_operations bso2,

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

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

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(+)
421: AND wo1.department_id = bd1.department_id
422: AND wo2.wip_entity_id = wdj.wip_entity_id
423: AND wo2.organization_id = wdj.organization_id
424: AND wo2.operation_seq_num =

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

430: wo3.operation_seq_num > wo1.operation_seq_num) OR
431: (wo1.next_operation_seq_num IS NULL AND
432: wo3.operation_seq_num >= wo1.operation_seq_num))
433: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
434: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
435: AND wo2.department_id = bd2.department_id
436: AND wdj.primary_item_id = msik.inventory_item_id
437: AND wdj.organization_id = msik.organization_id
438: AND wdj.wip_entity_id = p_wip_entity_id