APPS.BOM_VALIDATE dependencies on MTL_SERIAL_NUMBERS

Line 168: * asset group in the table MTL_SERIAL_NUMBERS.

164: *
165: * Return : True if the serial number is valid else
166: * False
167: * Purpose : Verify that the serial number is valid for the
168: * asset group in the table MTL_SERIAL_NUMBERS.
169: *******************************************************************/
170:
171: FUNCTION Asset_Group_Serial_Number
172: ( p_assembly_item_id IN NUMBER,

Line 190: SELECT NULL FROM mtl_serial_numbers WHERE

186: RETURN (TRUE);
187: END IF;
188:
189: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
190: SELECT NULL FROM mtl_serial_numbers WHERE
191: inventory_item_id = p_assembly_item_id AND
192: current_organization_id = p_organization_id AND
193: serial_number = p_serial_number);
194: