APPS.INV_PHY_INV_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 878: FROM mtl_system_items

874:
875: -- Calculate the tag quantity at standard uom
876: SELECT primary_uom_code
877: INTO l_item_standard_uom
878: FROM mtl_system_items
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881: -- I assume that the primary_uom_code is always given for an item
882: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions

Line 1096: FROM mtl_system_items

1092: END IF;
1093: -- Calculate the tag quantity at standard uom
1094: SELECT primary_uom_code
1095: INTO l_item_standard_uom
1096: FROM mtl_system_items
1097: WHERE inventory_item_id = p_inventory_item_id
1098: AND organization_id = p_organization_id;
1099: -- I assume that the primary_uom_code is always given for an item
1100: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions

Line 1297: FROM mtl_system_items

1293: print_debug('Get the primary UOM code: ' || 'Item ID: ' || l_inventory_item_id || ': ' || 'Org ID: ' || p_organization_id);
1294: END IF;
1295: SELECT primary_uom_code
1296: INTO l_standard_uom_code
1297: FROM mtl_system_items
1298: WHERE inventory_item_id = l_inventory_item_id
1299: AND organization_id = p_organization_id;
1300:
1301: -- Call the label printing API if an adjustment is required

Line 1430: FROM mtl_system_items

1426: SELECT revision_qty_control_code, location_control_code,
1427: lot_control_code, serial_number_control_code
1428: INTO l_rev_code, l_location_control_code,
1429: l_lot_control_code, l_serial_control_code
1430: FROM mtl_system_items
1431: WHERE inventory_item_id = p_inventory_item_id
1432: AND organization_id = p_organization_id;
1433:
1434: -- Get the adjustment ID if it is existing

Line 1710: FROM mtl_system_items

1706: IF (v_lpn_id.inventory_item_id IS NOT NULL) THEN
1707: -- Get the primary UOM for the container inventory item
1708: SELECT primary_uom_code
1709: INTO l_temp_uom_code
1710: FROM mtl_system_items
1711: WHERE inventory_item_id = v_lpn_id.inventory_item_id
1712: AND organization_id = v_lpn_id.organization_id;
1713:
1714: IF (l_debug = 1) THEN

Line 1769: FROM mtl_system_items

1765: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
1766: -- Get the primary UOM for the serialized item
1767: SELECT primary_uom_code
1768: INTO l_temp_uom_code
1769: FROM mtl_system_items
1770: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
1771: AND organization_id = v_lpn_serial_content.current_organization_id;
1772:
1773: IF (l_debug = 1) THEN

Line 2307: l_uom_code mtl_system_items.primary_uom_code%TYPE;

2303:
2304: l_transaction_header_id NUMBER := p_txn_header_id;
2305: l_transaction_temp_id NUMBER;
2306: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
2307: l_uom_code mtl_system_items.primary_uom_code%TYPE;
2308: l_sec_uom_code mtl_system_items.secondary_uom_code%TYPE;
2309: l_debug NUMBER := Nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2310: l_proc_name VARCHAR2(20) := 'PHY_INV_SUB_XFER ';
2311:

Line 2308: l_sec_uom_code mtl_system_items.secondary_uom_code%TYPE;

2304: l_transaction_header_id NUMBER := p_txn_header_id;
2305: l_transaction_temp_id NUMBER;
2306: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
2307: l_uom_code mtl_system_items.primary_uom_code%TYPE;
2308: l_sec_uom_code mtl_system_items.secondary_uom_code%TYPE;
2309: l_debug NUMBER := Nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2310: l_proc_name VARCHAR2(20) := 'PHY_INV_SUB_XFER ';
2311:
2312: l_period_id NUMBER;