DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on BOM_STANDARD_OPERATIONS

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 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 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