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 2282: mtl_system_items_kfv msik

2278: --performace fix. Bug 3444172. Modified the query below.
2279: SELECT DISTINCT pll.ship_to_organization_id
2280: INTO l_rti_rec.to_organization_id
2281: FROM po_line_locations pll, po_headers ph, po_lines pl,
2282: mtl_system_items_kfv msik
2283: WHERE ph.segment1 = l_rti_rec.document_num
2284: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2285: OR (msik.concatenated_segments = l_rti_rec.item_num
2286: AND l_rti_rec.item_id IS NULL))

Line 2322: FROM mtl_system_items_kfv msik,

2318: mp.organization_id
2319: INTO l_prim_uom_code,
2320: l_item_id,
2321: l_to_organization_id
2322: FROM mtl_system_items_kfv msik,
2323: mtl_parameters mp
2324: WHERE mp.organization_id = l_rti_rec.to_organization_id
2325: AND msik.inventory_item_id = l_rti_rec.item_id
2326: AND mp.organization_id = msik.organization_id;

Line 2335: FROM mtl_system_items_kfv msik,

2331: mp.organization_id
2332: INTO l_prim_uom_code,
2333: l_item_id,
2334: l_to_organization_id
2335: FROM mtl_system_items_kfv msik,
2336: mtl_parameters mp
2337: WHERE mp.organization_id = l_rti_rec.to_organization_id
2338: AND msik.concatenated_segments = l_rti_rec.item_num
2339: AND mp.organization_id = msik.organization_id;

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_code = l_rti_rec.to_organization_code
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_code = l_rti_rec.to_organization_code
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;