APPS.CSI_ITEM_INSTANCE_GRP dependencies on MTL_PARAMETERS

Line 65: FROM mtl_parameters

61: -- 2 - None
62: BEGIN
63: SELECT lot_number_uniqueness -- Lot number uniqueness
64: INTO l_lot_type
65: FROM mtl_parameters
66: WHERE organization_id = p_instance_rec.vld_organization_id;
67: EXCEPTION
68: WHEN no_data_found THEN
69: l_return_value := FALSE;

Line 121: FROM mtl_parameters

117: --
118: BEGIN
119: SELECT serial_number_type -- serial number uniqueness control
120: INTO l_serial_type
121: FROM mtl_parameters
122: WHERE organization_id = p_instance_rec.vld_organization_id;
123: EXCEPTION
124: WHEN no_data_found THEN
125: l_return_value := FALSE;

Line 249: mtl_parameters p

245: BEGIN
246: SELECT 'x'
247: INTO l_temp
248: FROM mtl_serial_numbers s,
249: mtl_parameters p
250: WHERE s.current_organization_id = p.organization_id
251: AND s.serial_number = p_instance_rec.serial_number
252: AND p.serial_number_type = 3
253: AND ROWNUM = 1;