DBA Data[Home] [Help]

APPS.WSMPGENE dependencies on WIP_ENTITIES

Line 23: wip_entities we

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;

Line 361: --** FROM wip_entities we,

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

Line 379: FROM wip_entities we,

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