APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 502: FROM mtl_system_items

498: /*Derive the primary quantity */
499: BEGIN
500: SELECT primary_uom_code
501: INTO l_start_primary_uom
502: FROM mtl_system_items
503: WHERE organization_id = l_mti_csr.organization_id
504: AND inventory_item_id = l_mti_csr.inventory_item_id;
505: EXCEPTION
506: WHEN NO_DATA_FOUND

Line 774: FROM mtl_system_items

770:
771: /*Support for Lot Serial */
772: SELECT serial_number_control_code
773: INTO l_serial_code
774: FROM mtl_system_items
775: WHERE inventory_item_id = l_mti_csr.inventory_item_id
776: AND organization_id = l_mti_csr.organization_id;
777:
778: IF (l_debug = 1)

Line 2426: FROM mtl_system_items

2422: END IF;
2423:
2424: SELECT DECODE (serial_number_control_code, 2, 'Y', 5, 'Y', 'N')
2425: INTO l_is_serial_controlled
2426: FROM mtl_system_items
2427: WHERE inventory_item_id = l_st_item_id_tbl (1)
2428: AND organization_id = l_st_org_id_tbl (1);
2429: EXCEPTION
2430: WHEN OTHERS

Line 3227: FROM mtl_system_items

3223: END IF;
3224:
3225: SELECT DECODE (serial_number_control_code, 2, 'Y', 5, 'Y', 'N')
3226: INTO l_is_serial_controlled
3227: FROM mtl_system_items
3228: WHERE inventory_item_id = l_st_item_id_tbl (1)
3229: AND organization_id = l_st_org_id_tbl (1);
3230: EXCEPTION
3231: WHEN OTHERS

Line 4186: FROM mtl_system_items

4182: SELECT DECODE (serial_number_control_code, 2, 'Y'
4183: , 5, 'Y',
4184: 'N')
4185: INTO l_is_serial_controlled
4186: FROM mtl_system_items
4187: WHERE inventory_item_id = l_st_item_id_tbl (1)
4188: AND organization_id = l_st_org_id_tbl (1);
4189: EXCEPTION
4190: WHEN OTHERS