APPS.GME_TRANSACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1600: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;

1596:
1597: -- Bug 12391271
1598: l_prim_qty NUMBER;
1599: l_primary_uom VARCHAR2(3);
1600: l_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1601:
1602: -- Bug 14065291
1603: l_secondary_qty NUMBER;
1604: l_secondary_uom VARCHAR2(3);

Line 1609: FROM mtl_system_items_b i, mtl_system_items_kfv k

1605:
1606: -- Bug 14065291
1607: CURSOR Cur_get_material_info (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
1608: SELECT i.primary_uom_code, k.concatenated_segments, i.secondary_uom_code
1609: FROM mtl_system_items_b i, mtl_system_items_kfv k
1610: WHERE v_inventory_item_id = i.inventory_item_id
1611: AND v_organization_id = i.organization_id
1612: AND v_inventory_item_id = k.inventory_item_id
1613: AND v_organization_id = k.organization_id;

Line 2217: FROM mtl_system_items_kfv

2213: x_return_status := l_return_status;
2214: WHEN material_status_err THEN
2215: SELECT substr(concatenated_segments,1,100)
2216: INTO l_item
2217: FROM mtl_system_items_kfv
2218: WHERE organization_id = l_mmti_rec.organization_id
2219: AND inventory_item_id = l_mmti_rec.inventory_item_id;
2220: OPEN get_location(l_mmti_rec.organization_id, l_mmti_rec.subinventory_code, l_mmti_rec.locator_id);
2221: FETCH get_location INTO l_locator;

Line 2542: FROM mtl_system_items_kfv

2538: EXCEPTION
2539: WHEN material_status_err THEN
2540: SELECT substr(concatenated_segments,1,100)
2541: INTO l_item
2542: FROM mtl_system_items_kfv
2543: WHERE organization_id = gme_common_pvt.g_organization_id
2544: AND inventory_item_id = l_inventory_item_id;
2545: SELECT transaction_type_name
2546: INTO l_type