DBA Data[Home] [Help]

APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on MTL_SERIAL_NUMBERS

Line 569: FROM mtl_serial_numbers

565: IF p_organization_id IS NULL OR p_inventory_item_id IS NULL OR p_serial_number IS NULL THEN
566: RETURN NULL;
567: ELSE
568: SELECT owning_department_id INTO l_owning_dept_id
569: FROM mtl_serial_numbers
570: WHERE current_organization_id = p_organization_id
571: AND inventory_item_id = p_inventory_item_id
572: AND serial_number = p_serial_number;
573:

Line 1069: FROM mtl_serial_numbers

1065: THEN
1066: RETURN NULL;
1067: ELSE
1068: SELECT gen_object_id INTO l_gen_object_id
1069: FROM mtl_serial_numbers
1070: WHERE current_organization_id = p_organization_id
1071: AND inventory_item_id = p_inventory_item_id
1072: AND serial_number = p_serial_number;
1073: