APPS.INV_QUANTITY_TREE_UE dependencies on MTL_SYSTEM_ITEMS

Line 342: FROM MTL_SYSTEM_ITEMS

338: IF p_uom_code IS NOT NULL THEN
339: BEGIN
340: SELECT Primary_Uom_Code
341: INTO l_primary_uom_code
342: FROM MTL_SYSTEM_ITEMS
343: WHERE Organization_Id = p_organization_id
344: AND Inventory_Item_Id = p_inventory_item_id;
345: EXCEPTION
346: WHEN no_data_found THEN

Line 644: FROM mtl_system_items

640: l_lot_control NUMBER;
641: CURSOR get_item_details( org_id IN NUMBER
642: , item_id IN NUMBER) IS
643: SELECT NVL(lot_control_code, 1)
644: FROM mtl_system_items
645: WHERE inventory_item_id = item_id
646: AND organization_id = org_id;
647:
648: l_demand_header_type NUMBER;

Line 904: FROM MTL_SYSTEM_ITEMS

900: IF p_uom_code IS NOT NULL THEN
901: BEGIN
902: SELECT Primary_Uom_Code
903: INTO l_primary_uom_code
904: FROM MTL_SYSTEM_ITEMS
905: WHERE Organization_Id = p_organization_id
906: AND Inventory_Item_Id = p_inventory_item_id;
907: EXCEPTION
908: WHEN no_data_found THEN

Line 1320: FROM mtl_system_items

1316: l_lot_control NUMBER;
1317: CURSOR get_item_details( org_id IN NUMBER
1318: , item_id IN NUMBER) IS
1319: SELECT NVL(lot_control_code, 1)
1320: FROM mtl_system_items
1321: WHERE inventory_item_id = item_id
1322: AND organization_id = org_id;
1323:
1324: l_demand_header_type NUMBER;

Line 1444: FROM MTL_SYSTEM_ITEMS

1440: IF p_uom_code IS NOT NULL THEN
1441: BEGIN
1442: SELECT Primary_Uom_Code
1443: INTO l_primary_uom_code
1444: FROM MTL_SYSTEM_ITEMS
1445: WHERE Organization_Id = p_organization_id
1446: AND Inventory_Item_Id = p_inventory_item_id;
1447: EXCEPTION
1448: WHEN no_data_found THEN