APPS.AHL_LTP_REQST_MATRL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 329: mtl_system_items_vl mt

325: it.priority,
326: it.uom_code,
327: it.quantity
328: FROM ahl_item_associations_vl it,
329: mtl_system_items_vl mt
330: WHERE it.inventory_item_id = mt.inventory_item_id
331: AND item_group_id = C_ITEM_GROUP_ID
332: AND mt.organization_id = C_ORG_ID
333: -- Fix for bug # 4109330

Line 364: FROM mtl_system_items_vl

360: C_ORG_ID IN NUMBER)
361: IS
362: SELECT inventory_item_id,
363: primary_uom_code
364: FROM mtl_system_items_vl
365: WHERE inventory_item_id = C_ITEM_ID
366: AND organization_id = C_ORG_ID;
367: --Get quanity from rt oper materisl if null
368: CURSOR Quantity_cur (c_rt_oper_mat_id IN NUMBER)

Line 784: FROM mtl_system_items_vl

780: CURSOR Get_Inv_Item_cur (c_item_desc IN VARCHAR2,
781: c_org_id IN NUMBER)
782: IS
783: SELECT inventory_item_id
784: FROM mtl_system_items_vl
785: WHERE concatenated_segments = c_item_desc
786: AND organization_id = c_org_id;
787:
788: -- Serial Number Resrvation Change Starts

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

899: fnd_log.string
900: (
901: l_log_error,
902: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
903: 'Inventory Item doesnt exist in Mtl System Items Vl'
904: );
905: END IF;
906: CLOSE Get_Inv_Item_Cur;
907: RAISE FND_API.G_EXC_ERROR;

Line 1622: mtl_system_items_vl mt

1618: C_ORG_ID IN NUMBER)
1619: IS
1620: SELECT it.inventory_item_id
1621: FROM ahl_item_associations_vl it,
1622: mtl_system_items_vl mt
1623: WHERE it.inventory_item_id = mt.inventory_item_id
1624: AND item_group_id = C_ITEM_GROUP_ID
1625: AND mt.organization_id = C_ORG_ID
1626: AND it.interchange_type_code in ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE')

Line 3603: FROM mtl_system_items_vl

3599: CURSOR Get_primary_uom (C_ITEM_ID IN NUMBER,
3600: C_ORG_ID IN NUMBER)
3601: IS
3602: SELECT primary_uom_code
3603: FROM mtl_system_items_vl
3604: WHERE inventory_item_id = C_ITEM_ID
3605: AND organization_id = C_ORG_ID;
3606:
3607: BEGIN