61: SELECT /*+ ORDERED */
62: msi.concatenated_segments,
63: dj.organization_id
64: FROM wip_discrete_jobs dj,
65: mtl_system_items_kfv msi
66: WHERE dj.wip_entity_id = wip_ent_id
67: AND dj.primary_item_id = msi.inventory_item_id
68: AND dj.organization_id = msi.organization_id;
69:
322: SELECT
323: msi.concatenated_segments,
324: dj.organization_id
325: FROM wip_discrete_jobs dj,
326: mtl_system_items_kfv msi
327: WHERE dj.wip_entity_id = wip_ent_id
328: AND dj.primary_item_id = msi.inventory_item_id
329: AND dj.organization_id = msi.organization_id;
330:
377: msi.concatenated_segments,
378: dj.organization_id
379: FROM wip_entities we,
380: wip_discrete_jobs dj,
381: mtl_system_items_kfv msi
382: WHERE we.wip_entity_id = wip_ent_id
383: AND we.wip_entity_id = dj.wip_entity_id
384: AND dj.primary_item_id = msi.inventory_item_id
385: AND dj.organization_id = msi.organization_id;