eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2311: mtl_system_items_kfv msik

2307: --performace fix. Bug 3444172. Modified the query below.
2308: SELECT DISTINCT pll.ship_to_organization_id
2309: INTO l_rti_rec.to_organization_id
2310: FROM po_line_locations pll, po_headers ph, po_lines pl,
2311: mtl_system_items_kfv msik
2312: WHERE ph.segment1 = l_rti_rec.document_num
2313: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2314: OR (msik.concatenated_segments = l_rti_rec.item_num
2315: AND l_rti_rec.item_id IS NULL))

Line 2351: FROM mtl_system_items_kfv msik,

2347: mp.organization_id
2348: INTO l_prim_uom_code,
2349: l_item_id,
2350: l_to_organization_id
2351: FROM mtl_system_items_kfv msik,
2352: mtl_parameters mp
2353: WHERE mp.organization_id = l_rti_rec.to_organization_id
2354: AND msik.inventory_item_id = l_rti_rec.item_id
2355: AND mp.organization_id = msik.organization_id;

Line 2364: FROM mtl_system_items_kfv msik,

2360: mp.organization_id
2361: INTO l_prim_uom_code,
2362: l_item_id,
2363: l_to_organization_id
2364: FROM mtl_system_items_kfv msik,
2365: mtl_parameters mp
2366: WHERE mp.organization_id = l_rti_rec.to_organization_id
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;

Line 2380: FROM mtl_system_items_kfv msik,

2376: mp.organization_id
2377: INTO l_prim_uom_code,
2378: l_item_id,
2379: l_to_organization_id
2380: FROM mtl_system_items_kfv msik,
2381: mtl_parameters mp
2382: WHERE mp.organization_code = l_rti_rec.to_organization_code
2383: AND msik.inventory_item_id = l_rti_rec.item_id
2384: AND mp.organization_id = msik.organization_id;

Line 2393: FROM mtl_system_items_kfv msik,

2389: mp.organization_id
2390: INTO l_prim_uom_code,
2391: l_item_id,
2392: l_to_organization_id
2393: FROM mtl_system_items_kfv msik,
2394: mtl_parameters mp
2395: WHERE mp.organization_code = l_rti_rec.to_organization_code
2396: AND msik.concatenated_segments = l_rti_rec.item_num
2397: AND mp.organization_id = msik.organization_id;