APPS.AHL_LTP_REQST_MATRL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 269: mtl_system_items_vl mt

265: it.priority,
266: it.uom_code,
267: it.quantity
268: FROM ahl_item_associations_vl it,
269: mtl_system_items_vl mt
270: WHERE it.inventory_item_id = mt.inventory_item_id
271: AND item_group_id = C_ITEM_GROUP_ID
272: AND mt.organization_id = C_ORG_ID
273: -- Fix for bug # 4109330

Line 304: FROM mtl_system_items_vl

300: C_ORG_ID IN NUMBER)
301: IS
302: SELECT inventory_item_id,
303: primary_uom_code
304: FROM mtl_system_items_vl
305: WHERE inventory_item_id = C_ITEM_ID
306: AND organization_id = C_ORG_ID;
307: --Get quanity from rt oper materisl if null
308: CURSOR Quantity_cur (c_rt_oper_mat_id IN NUMBER)

Line 773: FROM mtl_system_items_vl

769: CURSOR Get_Inv_Item_cur (c_item_desc IN VARCHAR2,
770: c_org_id IN NUMBER)
771: IS
772: SELECT inventory_item_id
773: FROM mtl_system_items_vl
774: WHERE concatenated_segments = c_item_desc
775: AND organization_id = c_org_id;
776:
777: -- Serial Number Resrvation Change Starts

Line 892: 'Inventory Item doesnt exist in Mtl System Items Vl'

888: fnd_log.string
889: (
890: l_log_error,
891: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
892: 'Inventory Item doesnt exist in Mtl System Items Vl'
893: );
894: END IF;
895: CLOSE Get_Inv_Item_Cur;
896: RAISE FND_API.G_EXC_ERROR;