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 1274: FROM mtl_system_items_kfv

1270: -- Item
1271: IF l_material_rec.inventory_item_id IS NOT NULL THEN
1272: BEGIN
1273: SELECT concatenated_segments,description INTO l_material_rec.item, l_material_rec.item_description
1274: FROM mtl_system_items_kfv
1275: WHERE organization_id = l_material_rec.organization_id
1276: AND inventory_item_id = l_material_rec.inventory_item_id;
1277: EXCEPTION
1278: WHEN no_data_found THEN

Line 2279: FROM mtl_system_items_kfv

2275: l_material_rec.item := p_item;
2276: ELSIF l_material_rec.inventory_item_id IS NOT NULL THEN
2277: BEGIN
2278: SELECT concatenated_segments,description INTO l_material_rec.item, l_material_rec.item_description
2279: FROM mtl_system_items_kfv
2280: WHERE organization_id = l_material_rec.organization_id
2281: AND inventory_item_id = l_material_rec.inventory_item_id;
2282: EXCEPTION
2283: WHEN NO_DATA_FOUND THEN

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

2684: msi.inventory_item_id ITEM_ID,
2685: --round(oel.ordered_quantity/oel1.ordered_quantity) bom_qty,
2686: oel.ordered_quantity ORD_QTY,
2687: OEL.top_model_LINE_ID
2688: FROM oe_order_lines_all oel, mtl_system_items_kfv msi, oe_order_lines_all oel1
2689: WHERE oel.inventory_item_id = msi.inventory_item_id
2690: AND oel.ship_from_org_id = msi.organization_id
2691: AND oel1.inventory_item_id = msi.inventory_item_id
2692: AND oel1.ship_from_org_id = msi.organization_id