DBA Data[Home] [Help]

APPS.WSMPGENE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 65: mtl_system_items_kfv msi

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:

Line 326: mtl_system_items_kfv msi

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:

Line 381: mtl_system_items_kfv msi

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;