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.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1337: FROM mtl_system_items_kfv

1333: -- Item
1334: IF l_material_rec.inventory_item_id IS NOT NULL THEN
1335: BEGIN
1336: SELECT concatenated_segments,description INTO l_material_rec.item, l_material_rec.item_description
1337: FROM mtl_system_items_kfv
1338: WHERE organization_id = l_material_rec.organization_id
1339: AND inventory_item_id = l_material_rec.inventory_item_id;
1340: EXCEPTION
1341: WHEN no_data_found THEN

Line 2352: FROM mtl_system_items_kfv

2348: l_material_rec.item := p_item;
2349: ELSIF l_material_rec.inventory_item_id IS NOT NULL THEN
2350: BEGIN
2351: SELECT concatenated_segments,description INTO l_material_rec.item, l_material_rec.item_description
2352: FROM mtl_system_items_kfv
2353: WHERE organization_id = l_material_rec.organization_id
2354: AND inventory_item_id = l_material_rec.inventory_item_id;
2355: EXCEPTION
2356: WHEN NO_DATA_FOUND THEN

Line 2761: FROM oe_order_lines_all oel, mtl_system_items_kfv msi, oe_order_lines_all oel1

2757: msi.inventory_item_id ITEM_ID,
2758: --round(oel.ordered_quantity/oel1.ordered_quantity) bom_qty,
2759: oel.ordered_quantity ORD_QTY,
2760: OEL.top_model_LINE_ID
2761: FROM oe_order_lines_all oel, mtl_system_items_kfv msi, oe_order_lines_all oel1
2762: WHERE oel.inventory_item_id = msi.inventory_item_id
2763: AND oel.ship_from_org_id = msi.organization_id
2764: AND oel1.inventory_item_id = msi.inventory_item_id
2765: AND oel1.ship_from_org_id = msi.organization_id