DBA Data[Home] [Help]

APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 256: 'FROM mtl_item_categories mic, mtl_system_items_kfv msi, '||

252: -- CURSOR c_inventory_items(c_category_id NUMBER,
253: -- c_category_set_id NUMBER, c_organization_id NUMBER) IS
254: l_sql VARCHAR2(2000) := 'SELECT mic.inventory_item_id, '||
255: 'msi.concatenated_segments, ms.description '||
256: 'FROM mtl_item_categories mic, mtl_system_items_kfv msi, '||
257: ' mtl_system_items_vl ms ' ||
258: 'WHERE mic.inventory_item_id = ms.inventory_item_id ' ||
259: ' AND mic.organization_id = ms.organization_id ' ||
260: ' AND mic.organization_id = msi.organization_id ' ||

Line 641: FROM ibe_dsp_section_items si, mtl_system_items_kfv msi,

637: c_organization_id NUMBER, c_start_date DATE,
638: c_end_date DATE) IS
639: SELECT si.section_item_id, si.inventory_item_id,
640: msi.concatenated_segments, ms.description
641: FROM ibe_dsp_section_items si, mtl_system_items_kfv msi,
642: mtl_system_items_vl ms
643: WHERE si.inventory_item_id = ms.inventory_item_id
644: AND si.organization_id = ms.organization_id
645: AND si.organization_id = msi.organization_id