19: we.wip_entity_id,
20: dj.start_quantity,
21: dj.organization_id
22: FROM wip_discrete_jobs dj,
23: wip_entities we
24: WHERE we.wip_entity_id = wip_ent_id
25: AND we.wip_entity_id = dj.wip_entity_id;
26: BEGIN
27: OPEN get_wip_info;
357: --** we.wip_entity_id,
358: --** dj.start_quantity,
359: --** msi.segment1,
360: --** dj.organization_id
361: --** FROM wip_entities we,
362: --** wip_discrete_jobs dj,
363: --** mtl_system_items msi
364: --** WHERE we.wip_entity_id = wip_ent_id
365: --** AND we.wip_entity_id = dj.wip_entity_id
375: we.wip_entity_id,
376: dj.start_quantity,
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