APPS.WSMPGENE dependencies on WIP_DISCRETE_JOBS

Line 22: FROM wip_discrete_jobs dj,

18: lpad(we.wip_entity_name,length(we.wip_entity_name)+(4*level_no)),
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

Line 52: --** FROM wip_discrete_jobs dj,

48: --** CURSOR get_ent_info IS
49: --** SELECT /*+ ORDERED */
50: --** msi.segment1,
51: --** dj.organization_id
52: --** FROM wip_discrete_jobs dj,
53: --** mtl_system_items msi
54: --** WHERE dj.wip_entity_id = wip_ent_id
55: --** AND dj.primary_item_id = msi.inventory_item_id
56: --** AND dj.organization_id = msi.organization_id;

Line 64: FROM wip_discrete_jobs dj,

60: CURSOR get_ent_info IS
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;

Line 288: FROM wip_discrete_jobs

284: x_err_msg OUT VARCHAR2) IS
285: CURSOR get_qty IS
286: SELECT
287: quantity_completed
288: FROM wip_discrete_jobs
289: WHERE wip_entity_id = wip_ent_id;
290: BEGIN
291: OPEN get_qty;
292: FETCH get_qty INTO qty;

Line 312: ** FROM wip_discrete_jobs dj,

308: /* CURSOR get_ent_info IS
309: ** SELECT
310: ** msi.segment1,
311: ** dj.organization_id
312: ** FROM wip_discrete_jobs dj,
313: ** mtl_system_items msi
314: ** WHERE dj.wip_entity_id = wip_ent_id
315: ** AND dj.primary_item_id = msi.inventory_item_id
316: ** AND dj.organization_id = msi.organization_id;

Line 325: FROM wip_discrete_jobs dj,

321: CURSOR get_ent_info IS
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;

Line 362: --** wip_discrete_jobs dj,

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
366: --** AND dj.primary_item_id = msi.inventory_item_id

Line 380: wip_discrete_jobs dj,

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
384: AND dj.primary_item_id = msi.inventory_item_id

Line 739: FROM wip_discrete_jobs

735: x_err_msg OUT VARCHAR2) IS
736: CURSOR get_qty IS
737: SELECT
738: start_quantity
739: FROM wip_discrete_jobs
740: WHERE wip_entity_id = wip_ent_id;
741: BEGIN
742: OPEN get_qty;
743: FETCH get_qty INTO qty;